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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

if you want known the existence or not of of database, you can use a query like :

select * from pg_database


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

System Engineer

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-2017 The PostgreSQL Global Development Group