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
pgSQL@Sheeky.Biz
Get Sheeky @ http://Sheeky.Biz