From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | small psql patch - show Schema name for \dt \dv \dS |
Date: | 2002-07-18 22:00:21 |
Message-ID: | 3D373A75.7040607@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
I can't remember who said they were working on schema related psql
changes, but I kept finding myself wishing I could see what schema a
table or view exists in when I use \dt, \dv, etc. So, here is a patch
which does just that.
It sorts on "Schema" first, and "Name" second.
It also changes the test for system objects to key off the namespace
name starting with 'pg_' instead of the object name.
Sample output:
test=# create schema testschema;
CREATE SCHEMA
test=# create view testschema.ts_view as select 1;
CREATE VIEW
test=# \dv
List of relations
Name | Schema | Type | Owner
--------------------+------------+------+----------
__testpassbyval | public | view | postgres
fooview | public | view | postgres
master_pg_proc | public | view | postgres
rmt_pg_proc | public | view | postgres
vw_dblink_get_pkey | public | view | postgres
vw_dblink_replace | public | view | postgres
ts_view | testschema | view | postgres
(7 rows)
If there are no objections, please apply.
Thanks!
Joe
Attachment | Content-Type | Size |
---|---|---|
psql-describe.2002.07.18.1.patch | text/plain | 3.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2002-07-18 23:00:05 | Re: [PATCHES] utils C files |
Previous Message | Tom Lane | 2002-07-18 20:40:18 | Re: Between Node |