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