From: | "Adam Lang" <aalang(at)rutgersinsurance(dot)com> |
---|---|
To: | "PGSQL General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: sql question |
Date: | 2000-09-27 19:20:33 |
Message-ID: | 006401c028b8$01cd5020$330a0a0a@Adam |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)commnav(dot)com>
> To: "Postgres (E-mail)" <pgsql-general(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | g.p.ciceri | 2000-09-27 19:40:22 | initialization phase for user-defined functions |
Previous Message | chris markiewicz | 2000-09-27 19:11:34 | sql question |