From: | dmp <danap(at)ttc-cmc(dot)net> |
---|---|
To: | Mansour Al Akeel <mansour(dot)alakeel(at)gmail(dot)com>, PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Reading schema information |
Date: | 2015-05-25 14:58:11 |
Message-ID: | 55633883.5060900@ttc-cmc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
dmp wrote:
> Mansour Al Akeel wrote:
>> 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.
>>
Hello,
I'm sorry, after testing, currently the given name IS_GENERATEDCOLUMN is
given the error as you describe. The index of 23 can be used to obtain the
results desired.
Did you search the mailing list for a report or issue on this?
danap.
From | Date | Subject | |
---|---|---|---|
Next Message | dmp | 2015-05-25 15:21:34 | Re: Reading schema information |
Previous Message | Mansour Al Akeel | 2015-05-25 14:51:50 | Re: Reading schema information |