Re: basic postgres questions...

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