On Mon, Mar 16, 2009 at 5:08 PM, Tena Sakai <tsakai@xxxxxxxxxxxxxx> wrote: > 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? You want insert: insert into my_table select yada from old_table; -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
