Thread: Looking for Mr. Autonum

Looking for Mr. Autonum

From
"E Westfield"
Date:
Greetings
Looking for how to build a table with a built in unique sequential numeric
key (primary optional) and then copy from a flat file to that same field.
Can not see on the _CREATE TABLE_  nor the _TYPE_ how to do so.  Is the OID
mentioned in the _COPY_ a possible.

I wish to have a new unique ID for any additions to the table without
haveing to programmatically create one.  This is done in other databases so
I am sure it is available in Postgresql.  Thank you for you help in this
slow learning one.



--
E Westfield
SCRIBE Network Coordinator
http://www.faire.net/SCRIBE