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: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
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



Attachment: psql_schemas.patch
Description: text/plain (45.5 KB)


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-2017 The PostgreSQL Global Development Group