EXISTS syntax for SELECT INTO?
| From: | Tony Grimes | Date: | Wed, 11 Oct 2006 20:39:48 +0000 |
| Subject: | EXISTS syntax for SELECT INTO? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42528@lists.php.net to get a copy of this message | ||
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 in advance,
Tony