<div style="background-color:"><div><p>Use pg_dump -c<p>this will drop the db objects before creating them<p>Priya<br
/><br/></div><div></div>>From: Sam Carleton <div></div>>To: pgsql-admin@postgresql.org <div></div>>Subject:
[ADMIN]sql scripts <div></div>>Date: Sat, 18 Oct 2003 22:37:00 -0400 <div></div>> <div></div>>I am new to
postgresand your mailing lists, please let me know if I <div></div>>am posting in the wrong list. <div></div>>
<div></div>>Iam working on creating my first database in Postgres. In the <div></div>>script that will create all
thetables for the firs time, I would <div></div>>like to have a conditional statement to delete a table, if it
<div></div>>alreadyexists. I know the other databases create such a condtional <div></div>>statement for you when
youexport the schema. What would such a <div></div>>conditional statement look like in Postgres's sql?
<div></div>><div></div>>sam <div></div>> <div></div>>---------------------------(end of
broadcast)---------------------------<div></div>>TIP 3: if posting/reading through Usenet, please send an
appropriate<div></div>> subscribe-nomail command to majordomo@postgresql.org so that your <div></div>> message
canget through to the mailing list cleanly <div></div></div><br clear="all" /><hr /><a
href="http://g.msn.com/8HMAENUS/2749??PS=">Frettingthat your Hotmail account may expire because you forgot to sign in
enough?Get Hotmail Extra Storage today! </a>