Thank you, Fernando. Thank you, Kevin. Regards,
Tena Sakai tsa...@gallo.ucsf.edu -----Original Message----- From: Fernando Arancibia [mailto:faranci...@iswitch.cl] Sent: Mon 3/16/2009 4:13 PM To: Tena Sakai Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] select into... Hi, try insert into my_table select * from old_table where (some_condition); bye Fernando. 2009/3/16 Tena Sakai <tsa...@gallo.ucsf.edu> > 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? > > Thank you in advance. > > Regards, > > Tena Sakai > tsa...@gallo.ucsf.edu > >
