DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=BFtgvARgg/wtfA4HC6TGXldfvMuflukq5n8d8NOtTtgxxFGeTcby7BkpXXlTey67XflKYKd5BZNXCDJ/HXWbSTJaWYtAIrI0MC9t0kdfucjJAEcaPs9c+1kggPXhyVmmFovw3/NosSON3DOkhpin4i/x9Dmr9UqcQXifX7OFmdU=
Message-ID: <4f4c2a010608161144v61381db8m2d9148915673757d@mail.gmail.com>
Date: Wed, 16 Aug 2006 14:44:58 -0400
From: "Jon Horsman" <horshaq@gmail.com>
To: pgsql-sql@postgresql.org
Subject: DB creation script questions
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hey All,

I'm new to postgres and am wondering what the recommended way of
creating an automated db creation script is.  I've reading the
postgres 8.1 manual but haven't seen much on this and google doesn't
seem to be bringing up much either.

I need to create a script that will create a database if it currently
doesn't exist on the system.  It will then create tables if they don't
already exist and populate the tables with some data if this data
doesn't currently exist.  This script must be able to be run over an
over without causing harm to the db.

I have previously used MySQL and was able to accomplish this very
simply using IF NOT EXISTS for the table and database creation but
this doesn't seem to be available for postgres and i'm looking for a
more robust solution anyways.

Is there a way that from a sql script file/shell script you can find
out if certain postgres tables/databases exist?

If someone can point me in the right direction it would be greatly appreciated.

Thanks,

Jon.