| 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 |