Re: Database creation - Mailing list pgsql-novice

From Bruno LEVEQUE
Subject Re: Database creation
Date
Msg-id Pine.LNX.4.58.0401262147190.3359@moissac.leveque.fr
Whole thread Raw
In response to Database creation  ("Marcel Wolf" <mwolfs@comcast.net>)
List 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.leveque@net6d.com
http://www.net6d.com

pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Problem with pg_hba.conf file in Postgres 7.3
Next
From: Jeff Eckermann
Date:
Subject: Re: Database creation