Re: test the existence of a database - Mailing list pgsql-sql

From Jerome Alet
Subject Re: test the existence of a database
Date
Msg-id Pine.LNX.3.96.1020226094012.24221A-100000@cortex.unice.fr
Whole thread Raw
In response to Re: test the existence of a database  (Erle Czar Mantos <erle@hindang.msuiit.edu.ph>)
List pgsql-sql
On Tue, 26 Feb 2002, Erle Czar Mantos wrote:

>     I do not see wat u r trying to mean? Do you want to test the
> existence of a database from your code or from the standard shell?
>     If you want to test from your code, you can try connecting to
> that database and if your connection is null, that means there
> might be no database present.

alternatively, you can connect to template1 dans do a :
SELECT * FROM pg_database;

hth.

Jerome Alet - alet@unice.fr - http://cortex.unice.fr/~jerome
Fac de Medecine de Nice        http://wwwmed.unice.fr 
Tel: (+33) 4 93 37 76 30     Fax: (+33) 4 93 53 15 15
28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE




pgsql-sql by date:

Previous
From: Erle Czar Mantos
Date:
Subject: Re: test the existence of a database
Next
From: "Matteo Beccati"
Date:
Subject: Timestamp output