Ray Stell wrote:
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
> to know the cmd to then delete a given database, and the underlying
tables.
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)
Then DROP DATABASE dbname; to delete it data and all.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
