Received: from bush.rutgersinsurance.com (IDENT:root@rutgersinsurance.com [38.138.71.194]) by hub.org (8.10.1/8.10.1) with ESMTP id e8RJIhr60984 for ; Wed, 27 Sep 2000 15:18:43 -0400 (EDT) Received: from Adam ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id PAA03310 for ; Wed, 27 Sep 2000 15:24:35 -0400 Message-ID: <006401c028b8$01cd5020$330a0a0a@Adam> From: "Adam Lang" To: "PGSQL General" Subject: Re: sql question Date: Wed, 27 Sep 2000 15:20:33 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200009/830 yeah insert into newtable (column1, column2, etc.) select * from temptable; Or however you need it. Here are the specifics: http://www.postgresql.org/docs/postgres/sql-insert.htm Adam Lang Systems Engineer Rutgers Casualty Insurance Company > ----- Original Message ----- > From: "chris markiewicz" > To: "Postgres (E-mail)" > Sent: Wednesday, September 27, 2000 3:11 PM > Subject: [GENERAL] sql question > > > > hello > > > > i just learned that some of the constraint altering functionality is not > > completely implemented. as a workaround, i selected all of the data from > > that table into a temp table, dropped and recreated the table (with the > > correct constraints), and now i want to re-insert the data. can this be > > done with a single sql stmt? > > > > thanks > > chris >