Re: small psql patch - show Schema name for \dt \dv \dS

Поиск
Список
Период
Сортировка
От greg@turnstep.com
Тема Re: small psql patch - show Schema name for \dt \dv \dS
Дата
Msg-id 20020802150122.8FD65475425@postgresql.org
обсуждение исходный текст
Ответ на small psql patch - show Schema name for \dt \dv \dS  (Joe Conway <mail@joeconway.com>)
Ответы Re: small psql patch - show Schema name for \dt \dv \dS  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> But so far I haven't seen any convincing argument why any client query
> would really want to look at current_schemas(), either.  What you
> actually want to know about is visibility, and computing that from
> current_schemas() is quite an expensive proposition.  I think what
> we need to expose is RelationIsVisible and friends, not BackendId.

I need something other than RelationIsVisible for psql for the case
when someone says "\d foo" - I need to be able to decide which
"foo" table I should display: pg_temp_1.foo, public.foo, greg.foo,
etc... which schemas to search, and the order to do the searching,
is why some sort of access to current_schemas() is needed.

Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200208021010

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE9SpfEvJuQZxSWSsgRAmw/AJ0RZ2vbx2zDQlFrLwRyVkZ1kvQB0ACgwyqT
9xugxhqatGJrrDWzzfez114=
=GZtD
-----END PGP SIGNATURE-----



В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: small psql patch - show Schema name for \dt \dv \dS
Следующее
От: Tom Lane
Дата:
Сообщение: Re: small psql patch - show Schema name for \dt \dv \dS