Skip site navigation (1) Skip section navigation (2)

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

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: small psql patch - show Schema name for \dt \dv \dS
Date: 2002-07-20 13:37:36
Message-ID: E17VuI1-0007Q0-00@granger.mail.mindspring.net (view raw or flat)
Thread:
Lists: 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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200207200933

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

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



Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2002-07-20 13:47:13
Subject: Re: small psql patch - show Schema name for \dt \dv \dS
Previous:From: Bruce MomjianDate: 2002-07-20 05:58:32
Subject: Re: fix bison warnings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group