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

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

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to