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
