Re: More schema support for psql - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: More schema support for psql
Date
Msg-id 200208102216.g7AMGbd09303@candle.pha.pa.us
Whole thread Raw
In response to More schema support for psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-patches
Tom Lane has applied this patch.  Thanks.

---------------------------------------------------------------------------

Greg Sabino Mullane wrote:
> -----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-----
>

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_stat_reset round 3
Next
From: Joe Conway
Date:
Subject: pg_settings view