| From: | Jerome Alet <alet(at)unice(dot)fr> |
|---|---|
| To: | Erle Czar Mantos <erle(at)hindang(dot)msuiit(dot)edu(dot)ph> |
| Cc: | "D'laila Pereira" <dpereira(at)students(dot)uiuc(dot)edu>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: test the existence of a database |
| Date: | 2002-02-26 08:40:50 |
| Message-ID: | Pine.LNX.3.96.1020226094012.24221A-100000@cortex.unice.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)unice(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matteo Beccati | 2002-02-26 09:36:20 | Timestamp output |
| Previous Message | Erle Czar Mantos | 2002-02-26 08:20:52 | Re: test the existence of a database |