Re: select into... - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: select into...
Date
Msg-id 49BE96B3.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to select into...  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-admin
>>> "Tena Sakai" <tsakai@gallo.ucsf.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

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: select into...
Next
From: "Tena Sakai"
Date:
Subject: Re: select into...