From: | Shane Ambler <pgsql(at)Sheeky(dot)Biz> |
---|---|
To: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
Cc: | bruce <bedouglas(at)earthlink(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: basic postgres questions... |
Date: | 2007-05-17 09:31:33 |
Message-ID: | 464C20F5.5010900@Sheeky.Biz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)Sheeky(dot)Biz
Get Sheeky @ http://Sheeky.Biz
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Balmer | 2007-05-17 09:48:35 | Granting privileges on views to group roles |
Previous Message | Sorin N. Ciolofan | 2007-05-17 09:14:17 | Re: increasing of the shared memory does not solve theproblem of "OUT of shared memory" |