From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Greg Sabino Mullane <greg(at)turnstep(dot)com> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: More schema support for psql |
Date: | 2002-08-10 22:16:36 |
Message-ID: | 200208102216.g7AMGbd09303@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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, 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2002-08-10 22:56:02 | pg_settings view |
Previous Message | Bruce Momjian | 2002-08-10 22:05:07 | Re: pg_stat_reset round 3 |