From: | Ryan Mahoney <ryan(at)paymentalliance(dot)net> |
---|---|
To: | Peter Choe <choepete(at)mindspring(dot)com>, postgres <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: database information |
Date: | 2001-07-30 20:37:13 |
Message-ID: | 5.0.2.1.0.20010730163336.039f9ec0@paymentalliance.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
SELECT datname FROM pg_database WHERE datname NOT LIKE 'template_';
-r
At 04:22 PM 7/30/01 -0400, Peter Choe wrote:
>how do i get the names of the databases that are created in postgres?
>
>is there a select statement similar to oracle?
>
>peter choe
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com)
>Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 166 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | will trillich | 2001-07-30 21:00:27 | openlinksw odbc vs. postgresql on linux ?? |
Previous Message | Peter Choe | 2001-07-30 20:22:24 | database information |