My advice:
Do a "drop table" first, ignoring any error that will result if it does not
exist, then do the "select
into". This is portable, too...
> 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
>
Mike Morris
The Music Place
1617 Willowhurst Avenue
San Jose, CA 95125
(408) 445-ARTS (2787)
------------------------------------
Your Free Humorous Quote:
When asked the difference between a tax collector and a taxidermist:
'The taxidermist takes only your skin.'
- Mark Twain
------------------------------------
