More schema support for psql

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: More schema support for psql
Date: 2002-06-24 16:32:38
Message-ID: E17MWdT-0007Da-00@tisch.mail.mindspring.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

-----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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200206241229

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

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

Attachment Content-Type Size
psql_schemas.patch text/plain 45.5 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2002-06-24 16:36:36 Re: show() function
Previous Message Bruce Momjian 2002-06-24 15:29:30 Re: [PATCHES] PostgreSQL 7.2.1 and Sun's C compiler under