[GENERAL] database information

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

Re: [GENERAL] database information

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