On Wed, May 16, 2007 at 08:21:59AM -0700, bruce wrote:
> hey.. .
>
> can someone point me to the cmds that i'd use in order to see what databases
> are created in my postgres app. i need to see what's here, and then i need
template1=# select datname, oid from pg_database;
datname | oid
-----------+-------
postgres | 10793
template1 | 1
template0 | 10792
wiki | 26158
(4 rows)
template1=# \l
List of databases
Name | Owner | Encoding
-----------+---------+----------
postgres | pgadmin | UTF8
template0 | pgadmin | UTF8
template1 | pgadmin | UTF8
wiki | pgadmin | UTF8
(4 rows)