Re: Select into

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Select into
Date: 2001-12-06 04:18:51
Message-ID: 20011205201736.Y20601-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Thu, 6 Dec 2001, Christopher Kings-Lynne wrote:

> Hi All,
>
> Is it possible to insert into a table based on a select from another table?
>
> The docs for SELECT INTO and like seem to imply you can only create a table
> based on a select, not append to an existing table.
>
> How do you do this?

I think you can use
INSERT INTO <table>(<cols>) SELECT ...

In response to

  • Select into at 2001-12-06 03:01:54 from Christopher Kings-Lynne

Browse pgsql-sql by date

  From Date Subject
Next Message Esger Abbink 2001-12-06 13:34:08 Re: need some help understanding sloq query
Previous Message Bruce Momjian 2001-12-06 04:10:07 Re: Select into