Serial - Mailing list pgsql-odbc

From andersen@modelcreator
Subject Serial
Date
Msg-id 001301c54a4a$78050f40$0301a8c0@modelcreator1
Whole thread Raw
List pgsql-odbc
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
 
 

pgsql-odbc by date:

Previous
From: Petr Odložil
Date:
Subject: Re: ForwardOnly ?
Next
From: lothar.behrens@lollisoft.de
Date:
Subject: Bool values under Mac OS X