select into...

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: select into...
Date: 2009-03-16 23:08:48
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C0378F7E6@egcrc-ex01.egcrc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Everybody,

I want to execute a query below:

select *
into my_table
from old_table
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. Is there any way to
get postgres to do what I want done?

Thank you in advance.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-03-16 23:12:05 Re: select into...
Previous Message Stefan Kaltenbrunner 2009-03-16 20:22:36 Re: deployment query