<html><div style='background-color:'><DIV>
<P>Use pg_dump -c</P>
<P>this will drop the db objects before creating them</P>
<P>Priya<BR><BR></P></DIV>
<DIV></DIV>>From: Sam Carleton <EHC(at)LINUX-INFO(dot)NET>
<DIV></DIV>>To: pgsql-admin(at)postgresql(dot)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 postgres and your mailing lists, please let me know if I
<DIV></DIV>>am posting in the wrong list.
<DIV></DIV>>
<DIV></DIV>>I am working on creating my first database in Postgres. In the
<DIV></DIV>>script that will create all the tables for the firs time, I would
<DIV></DIV>>like to have a conditional statement to delete a table, if it
<DIV></DIV>>already exists. I know the other databases create such a condtional
<DIV></DIV>>statement for you when you export 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(at)postgresql(dot)org so that your
<DIV></DIV>> message can get through to the mailing list cleanly
<DIV></DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMAENUS/2749??PS=">Fretting that your Hotmail account may expire because you forgot to sign in enough? Get Hotmail Extra Storage today! </a> </html>