Re: select into...

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