import java.sql.*;
public class pg17setA2
{
public static void main(String args[]) throws Exception
{
Connection con = null;
Statement stm = null;
ResultSet rs = null;
try
{
Class.forName("org.postgresql.Driver");
con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/rushya","postgres","");
if(con==null)
System.out.println("Connection Failed");
else
{
System.out.println("Connection Succesful");
DatabaseMetaData dbmd=con.getMetaData();
rs=dbmd.getTables(null,null,null,new String[] {"TABLE"});
System.out.println("Database Product Name\t"+dbmd.getDatabaseProductName());
System.out.println("Database Driver Version\t"+dbmd.getDatabaseProductVersion());
System.out.println("Database User Name\t"+dbmd.getUserName());
String table[]={"TABLE"};
while(rs.next())
{
System.out.println(rs.getString("TABLE_NAME"));
}
}
}
catch(Exception e)
{
System.out.println(e);
}
}
}