[PHP-DB] EXISTS syntax for SELECT INTO?

2006-10-11 Thread Tony Grimes
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. Thanks

Re: [PHP-DB] EXISTS syntax for SELECT INTO?

2006-10-11 Thread Chris
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