-----BEGIN PGP SIGNED MESSAGE-----
> I can't remember who said they were working on schema related psql
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-----
-----END PGP SIGNATURE-----
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2002-07-20 13:47:13|
|Subject: Re: small psql patch - show Schema name for \dt \dv \dS |
|Previous:||From: Bruce Momjian||Date: 2002-07-20 05:58:32|
|Subject: Re: fix bison warnings|