From: Adam Lang <aalang@rutgersinsurance.com>
To: PGSQL General <pgsql-general@postgresql.org>
Subject: Re: sql question
Date: Wed, 27 Sep 2000 15:20:33 -0400
Message-ID: <006401c028b8$01cd5020$330a0a0a@Adam> (raw)
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" <cmarkiew@commnav.com>
> To: "Postgres (E-mail)" <pgsql-general@postgresql.org>
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: aalang@rutgersinsurance.com
Subject: Re: sql question
In-Reply-To: <006401c028b8$01cd5020$330a0a0a@Adam>
References: <006401c028b8$01cd5020$330a0a0a@Adam>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox