From: | Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com> |
---|---|
To: | Marcel Wolf <mwolfs(at)comcast(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Database creation |
Date: | 2004-01-26 20:49:43 |
Message-ID: | Pine.LNX.4.58.0401262147190.3359@moissac.leveque.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
if you want known the existence or not of of database, you can use a query like :
select * from pg_database
Bruno
On Mon, 26 Jan 2004, Marcel Wolf wrote:
> I would like my application to start up and see if the database is there
> if not create it. I am not sure how to do it. When I try and query my
> database I get a fatal error and it won't accept my Create db command.
> Also I am converting from mysql and my table field names are a mixture
> of capitals and small letters. When these strings are passed to the
> database they are always changed to lowercase?
>
> Thanks for the help
> Marcel
>
>
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno(dot)leveque(at)net6d(dot)com
http://www.net6d.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2004-01-26 20:53:22 | Re: Database creation |
Previous Message | Oliver Elphick | 2004-01-26 20:39:01 | Re: Problem with pg_hba.conf file in Postgres 7.3 |