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
>