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

Reply via email to