X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 86BD7530C6 for ; Mon, 15 Aug 2005 04:50:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14378-09 for ; Mon, 15 Aug 2005 07:50:05 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id DD9F2530C4 for ; Mon, 15 Aug 2005 04:50:03 -0300 (ADT) Received: (qmail 20490 invoked from network); 15 Aug 2005 09:50:17 +0200 Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4) by boutiquenumerique.com with SMTP; 15 Aug 2005 09:50:17 +0200 To: tgh002 , pgsql-sql@postgresql.org Subject: Re: insert into / select from / serial problem References: <1123643026.939110.310310@g47g2000cwa.googlegroups.com> Message-ID: Date: Mon, 15 Aug 2005 09:49:56 +0200 From: PFC Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <1123643026.939110.310310@g47g2000cwa.googlegroups.com> User-Agent: Opera M2/8.0 (Linux, build 1095) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 required=5 tests=[AWL=0.005] X-Spam-Level: X-Archive-Number: 200508/92 X-Sequence-Number: 22320 On Wed, 10 Aug 2005 05:03:47 +0200, tgh002 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.