Use pg_dump -c
this will drop the db objects before creating them
Priya
>From: Sam Carleton <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: [ADMIN] sql scripts
>Date: Sat, 18 Oct 2003 22:37:00 -0400
>
>I am new to postgres and your mailing lists, please let me know if I
>am posting in the wrong list.
>
>I am working on creating my first database in Postgres. In the
>script that will create all the tables for the firs time, I would
>like to have a conditional statement to delete a table, if it
>already exists. I know the other databases create such a condtional
>statement for you when you export the schema. What would such a
>conditional statement look like in Postgres's sql?
>
>sam
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
