RE: Re: drop table if exists

Alright, but what about when you're writing a long dump file with all these
sequences, functions not speaking about the tables themselves.
When I drop something I wanna make sure it out the database (but still
cannot empty the whole database before), so I have

DROP TABLE ..., ..., ..., ...;
DROP FUNCTION ..., ..., ..., ...;
DROP SEQUENCE ..., ..., ..., ...;

If one of these were not there, the whole dump crashes and I need to restart
the process modifying the SQL file.

I'd LOVE to have a magic 'IF EXISTS' like in mySQL - make life easier
(Although I totally disrespect mySQL).
Has anyone a work around for this?

Thanks,
and yes, sorry for the late post, just looked you up guys.

Sincerely,

Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
maxim(at)phpbeginner(dot)com
www.phpbeginner.com

-----Original Message-----
From: Philip Hallstrom [mailto:philip(at)adhesivemedia(dot)com]
Sent: Wednesday, July 04, 2001 7:39 AM
To: Jason Watkins
Cc: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Re: drop table if exists

Just drop the table using "DROP TABLE mytable;" and ignore the error...
I'm sure there are fancy ways of doing it by accessing system tables, but
the above works for me.

On Tue, 3 Jul 2001, Jason Watkins wrote:

> How can I duplicate the behavior of:
>
> DROP TABLE IF EXISTS mytable;
>
> CREATE TABLE mytable (
> blah,
> blah
> );
>
> INSERT INTO mytable
> (blah)
> VALUES
> (blah);
>
> in other words, so that I have a single sql file that restores the
database
> to a known state.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster