Re: [GENERAL] database information

2001-07-30 Thread Ryan Mahoney
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 broad

[GENERAL] database information

2001-07-30 Thread Peter Choe
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