Select into

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Select into
Date: 2001-12-06 03:01:54
Message-ID: GNELIHDDFBOCMGBFGEFOKEKLCAAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Chris

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-12-06 04:10:07 Re: Select into
Previous Message Stephan Szabo 2001-12-05 22:05:33 Re: Getting matching and non-matching results (long)