Thread: 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

 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
>