Re: basic postgres questions...

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)