Bug #831: RFE - Schema list from psql

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #831: RFE - Schema list from psql
Date: 2002-12-01 21:44:07
Message-ID: 20021201214407.9ADD3476318@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dustin Sallings (dustin+pgsqlbugs(at)spy(dot)net) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
RFE - Schema list from psql

Long Description
psql should have a \d type builtin to list schemas in the current database.

Sample Code
select
ns.nspname as Schema,
u.usename as Owner,
ns.nspacl as ACL
from
pg_namespace ns,
pg_user u
where
u.usesysid = ns.nspowner
order by
ns.nspname

No file was uploaded with this report

Browse pgsql-bugs by date

  From Date Subject
Next Message Neil Conway 2002-12-01 21:54:01 Re: Bug #829: 7.3 crashes when trying to set variable to
Previous Message pgsql-bugs 2002-12-01 21:36:36 Bug #830: 7.3 - timespan missing?