pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>




view thread (71+ messages)  latest in thread

Message-ID: <006401c028b8$01cd5020$330a0a0a@Adam>
Permalink:  ../006401c028b8$01cd5020$330a0a0a@Adam/
Also on:    postgresql.org/message-id/006401c028b8$01cd5020$330a0a0a@Adam

 · 

reply

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