Re: select into...

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: select into...
Date: 2009-03-16 23:13:07
Message-ID: 49BE96B3.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>> "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:
> What I want is to append my_table. Is there any way
> to get postgres to do what I want done?

PostgreSQL supports the SQL standard syntax for this:

insert into my_table
select *
from old_table
where (some_condition);

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fernando Arancibia 2009-03-16 23:13:16 Re: select into...
Previous Message Scott Marlowe 2009-03-16 23:12:05 Re: select into...