Re: small psql patch - show Schema name for \dt \dv \dS

-----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-----