Re: EXISTS syntax for SELECT INTO?

Tony Grimes wrote:

I have a script that creates a table copy using SELECT INTO, but I want it to check if the new table already exists first. Does SQL support the EXISTS keyword for SELECT INTO statements (I'm running PG7)? If not, is there another way to do it in SQL? I'd rather not do it programmatically.

You could probably do it with a subquery: select into table1 from table2 where not in (select id from table1); Hopefully that gets you started :) -- Postgresql & php tutorials http://www.designmagick.com/