Re: Database creation

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

In response to

Browse pgsql-novice by date

  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