import java.sql.*;
import static java.lang.System.out;
class pg17setA3
{
  public static void main (String[]args)
  {
    Connection con = null;
    Statement stmt = null;
    ResultSet rs = null;
      try
    {
      Class.forName ("org.postgresql.Driver");
      con = DriverManager.getConnection ("jdbc:postgresql://127.0.0.1/rushya",
				     "postgres", "");
      if (con == null)
	System.out.println ("Connection Failed");
      else
	{
	  stmt = con.createStatement ();
	  rs = stmt.executeQuery ("SELECT * FROM student");
	  ResultSetMetaData rsmd = rs.getMetaData ();
	  int noOfColumns = rsmd.getColumnCount ();

	    System.out.println ("Number of columns: " + noOfColumns);

	  for (int i = 1; i <= noOfColumns; i++)
	    {
	      out.println ("Column No: " + i);
	      System.out.println ("Column Name: " + rsmd.getColumnName (i));
	      System.out.println ("Column Type: " + rsmd.getColumnType (i));
	      System.out.println ("Column Display Size: " +
				  rsmd.getColumnDisplaySize (i));
	      System.out.println ();
	    }
	}
    }
    catch (Exception e)
    {
      System.out.println (e.getMessage ());
    }
  }
}