]> granicus.if.org Git - postgresql/commit
I can't remember who said they were working on schema related psql
authorBruce Momjian <bruce@momjian.us>
Sat, 20 Jul 2002 05:57:31 +0000 (05:57 +0000)
committerBruce Momjian <bruce@momjian.us>
Sat, 20 Jul 2002 05:57:31 +0000 (05:57 +0000)
commit1ac7db4468e1989ea7c775ad786468b7fd3baa4e
treec0c99b4d155dd4c70944aa5dd6aea1dcad6aecd7
parent1ce03603ccc690c07987a64cbc2b53391c51f083
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)

Joe Conway
src/bin/psql/describe.c