Re: basic postgres questions...

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

In response to

Browse pgsql-general by date

  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"