Many thanks, Scott. Tena Sakai
-----Original Message----- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Mon 3/16/2009 4:12 PM To: Tena Sakai Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] select into... On Mon, Mar 16, 2009 at 5:08 PM, Tena Sakai <tsa...@gallo.ucsf.edu> 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;
