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 > >
