Received: from megazone.bigpanda.com ([63.150.15.178])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id fB64Ilm21828
	for <pgsql-sql@postgresql.org>; Wed, 5 Dec 2001 23:18:47 -0500 (EST)
	(envelope-from sszabo@megazone23.bigpanda.com)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id F1D63D5EF; Wed,  5 Dec 2001 20:18:51 -0800 (PST)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id E18285BEA; Wed,  5 Dec 2001 20:18:51 -0800 (PST)
Date: Wed, 5 Dec 2001 20:18:51 -0800 (PST)
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: Select into
In-Reply-To: <GNELIHDDFBOCMGBFGEFOKEKLCAAA.chriskl@familyhealth.com.au>
Message-ID: <20011205201736.Y20601-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200112/64
X-Sequence-Number: 5887


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 ...