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