DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=QUuDz79P/ifdn6zxPfMUCnWk4y70Lcj22WqKJfqeSuP2n/VCnaCwf3l972rbxPKe9d
	Qw9oJrBiRUEizvRTpg1/M3ZmXDnIZBcAnmJhM6xTRqHRXmM21HU4wTEee0xOR9IIYM5G
	D2bGT0CLMPWSDPiHDMVYmI00iVcosOVecfUG0=
MIME-Version: 1.0
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F7E6@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F7E6@egcrc-ex01.egcrc.org>
Date: Mon, 16 Mar 2009 17:12:05 -0600
Message-ID: <dcc563d10903161612t4ee3fe37k776764ecfc7dbed4@mail.gmail.com>
Subject: Re: select into...
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Mon, Mar 16, 2009 at 5:08 PM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> Hi Everybody,
>
> I want to execute a query below:
>
> =A0 select *
> =A0=A0=A0 into my_table
> =A0=A0=A0 from old_table
> =A0=A0 where (some_condition);
>
> The trouble is that the manual page states that this would
> "SELECT INTO creates a new table and fills it with data
> computed by a query."
>
> What I want is to append my_table.=A0 Is there any way to
> get postgres to do what I want done?

You want insert:

insert into my_table select yada from old_table;