subject:"\[GENERAL\] COPY INTO and the SERIAL data type"

Re: [GENERAL] COPY INTO and the SERIAL data type

2001-05-10 Thread Marc SCHAEFER

On Thu, 10 May 2001, Jonathan Sand wrote: > I want to use the COPY command to read a bunch of data files. These > files don't contain an id, so I want to use the SERIAL data type to > auto-number the generated rows. COPY complains. Destination table: CREATE TABLE destination (id SERIAL, truc

[GENERAL] COPY INTO and the SERIAL data type

2001-05-10 Thread Jonathan Sand

I'm running postgresql 7.0.3 on redhat 7.0. I want to use the COPY command to read a bunch of data files. These files don't contain an id, so I want to use the SERIAL data type to auto-number the generated rows. COPY complains. The other recommended method (besides using SERIAL) is to use OID's.