More schema support for psql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Please ignore the previous psql schema patch. It was merely a warmup.
This version covers most everything, and includes support for some
wildcard type matching of schemas and tables, while trying to remain
true to the pre-schema ways of doing things. As before, schema names
are always shown along with the table name, to clear up any confusion.
All references to pg_ tables are now fully qualified, since nothing
is stopping anyone from now running the command

CREATE TABLE public.pg_class (foobar date);

When a schema name is not given for things such as "\d foo", psql will do
its best to find the correct one. Unlike the previous patch, this is more
centralized so future changes will be easier. Currently, it does
temporary relations first (in other words, temporary schemas), then
non-public schemas (in order of last creation date), then public schemas,
and finally the system schemas. So \d pg_class will still work, and
"\d mytable" will finally show you your *temporary* "mytable". :)
You can see your permanent one by specifying the schema name, while
"\dt mytable" will show you all tables of that name in all schemas.

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

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

iD8DBQE9F0mYvJuQZxSWSsgRAkSYAJ9Mwh+IAV9rI6ZWKZNUq2szt1R9SwCdHBDp
I/8sd/2H7fmvalz1YWchLRA=
=xtFC
-----END PGP SIGNATURE-----