>>> "Tena Sakai" <tsakai@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin