Thank you, Fernando. Thank you, Kevin. Regards,
Tena Sakai [email protected] -----Original Message----- From: Fernando Arancibia [mailto:[email protected]] Sent: Mon 3/16/2009 4:13 PM To: Tena Sakai Cc: [email protected] 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 <[email protected]> > 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 > [email protected] > >
