Thread: Serial

Serial

From

"andersen@modelcreator"

Date:

26 April 2005, 10:27:38

Hello,

I don't know how to retrieve information via ODBC about the type "SERIAL". When creating a table with a column having this type it is changed into an int4 with a default value to a sequence as I understood it.

I can retrieve information about the type int4 and other attributes but I don't see how I can retrieve information about the sequencing.

I tried to use the following:

SQLColAttributes with attribute: SQL_COLUMN_AUTO_INCREMENT

SQLColAttribute with attribute: SQL_DESC_AUTO_UNIQUE_VALUE

SQLColumns has the default value empty (index 13).

Do you I have to query system tables to get this information?

Any comments?

Thanks,

Henning