Re: How to append records into a file which has serial - Mailing list pgsql-novice

> This worked for me:
>
> newschm3=> create table foo(x text,y text,a serial);

I think it just dawned on me -- I have to put the serial ID at
the end of the table structure, don't I?  So that the fields
correspond one-to-one, until the temp runs out of columns
where the master table has the SERIAL field.