Re: insert into / select from / serial problem - Mailing list pgsql-sql

On Wed, 10 Aug 2005 05:03:47 +0200, tgh002 <arnulfh@gmail.com> wrote:

> I am using a insert statement like:
>
> INSERT INTO newtable
> SELECT field1, field2 FROM anothertable
>
> newtable structure is: serial, varchar, varchar
>
> What syntax do I use to insert the serial field?   Ive tried something
> like:

Try :

INSERT INTO newtable (col1, col2) SELECT field1, field2 FROM anothertable

col1, col2 being the names of your columns that you want to put field1 and  
field2 into...

The serial will take care of itself.