Re: small psql patch - show Schema name for \dt \dv \dS - Mailing list pgsql-patches

From Greg Sabino Mullane
Subject Re: small psql patch - show Schema name for \dt \dv \dS
Date
Msg-id E17VuI1-0007Q0-00@granger.mail.mindspring.net
Whole thread Raw
In response to small psql patch - show Schema name for \dt \dv \dS  (Joe Conway <mail@joeconway.com>)
Responses Re: small psql patch - show Schema name for \dt \dv \dS  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I can't remember who said they were working on schema related psql
> changes

That would be me :)

> It also changes the test for system objects to key off the namespace
> name starting with 'pg_' instead of the object name.

I *think* you want to make it more specific and look for items in the
pg_catalog namespace, since this is where the system objects now live.

My own patch is pretty much complete - anyone have other feedback on it?

It appears as though current_schemas() is not quite finished - any
ideas on when this will be done? Once it accepts a boolean arg and
returns system schemas, and I can figure out a way to say "WHERE
nspname in current_schemas();" my psql patch should be complete. (and
the ** operator does not seem to work with current_schemas() either).
Currently, it does it's own schema search, which is better than nothing
until I can integrate current_schemas in there.


Greg Sabino Mullane  greg@turnstep.com
PGP Key: 0x14964AC8 200207200933

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE9OWeCvJuQZxSWSsgRArGvAKCcV127HpPZb8LC8kBZ2G8lUfMv6QCeNieu
exnojwcicrUpc1pI0eCOWRU=
=+ZUG
-----END PGP SIGNATURE-----



pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: fix bison warnings
Next
From: Tom Lane
Date:
Subject: Re: small psql patch - show Schema name for \dt \dv \dS