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

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 (view raw or flat)
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: psql_schemas.patch
Description: text/plain (45.5 KB)

Responses

pgsql-patches by date

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

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