Postgres Pro
Downloads
Home   >   mailing lists

Reading schema information - Mailing list pgsql-jdbc

From Mansour Al Akeel
Subject Reading schema information
Date
Msg-id CAFvvX=aeL4yfjA8Ng4Aek3W_FzO9zgihtRTXzaaaFw55d9GU1A@mail.gmail.com
Whole thread Raw
Responses Re: Reading schema information  (dmp <danap@ttc-cmc.net>)
List pgsql-jdbc
Tree view 
Sorry for missing the email subject in my previous email !

I am trying to get some information about a coloum using the method:

 DatabaseMetaData.getString("IS_GENERATEDCOLUMN")

However it is throwing an exception:

org.postgresql.util.PSQLException: The column name IS_GENERATEDCOLUMN
was not found in this ResultSet.

Based on javadoc for getColumns method:


http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String)


We have:

IS_GENERATEDCOLUMN String => Indicates whether this is a generated column

YES --- if this a generated column
NO --- if this not a generated column
empty string --- if it cannot be determined whether this is a generated column


My questions is, is this a bug ? if not, how can I obtain this
information about a column (if it's generated or not) ?


Thank you.

pgsql-jdbc by date:

Previous
From: Mansour Al Akeel
Date:
Subject:
Next
From: dmp
Date:
Subject: Re: Reading schema information