Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Jeff EckermannDate: 2004-01-26 20:53:22
Subject: Re: Database creation
Previous:From: Oliver ElphickDate: 2004-01-26 20:39:01
Subject: Re: Problem with pg_hba.conf file in Postgres 7.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group