Re: sql question

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
>

Browse pgsql-general by date

  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