| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: \d don't print all the tables |
| Date: | 2023-07-24 14:17:59 |
| Message-ID: | 20230724141759.g6zr35p6yndkqpox@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2023-Jul-24, Ron wrote:
> Add namespace_a and namespace_b to your search_path. Then it will work.
>
> Off the top of my head:
> SET search_path = namespace_a, namespace_b, public;
Actually it won't, because the table in the earliest schema "shadows"
any other tables of the same name in later schemas, so they won't show
in \d either.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"XML!" Exclaimed C++. "What are you doing here? You're not a programming
language."
"Tell that to the people who use me," said XML.
https://burningbird.net/the-parable-of-the-languages/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jian he | 2023-07-24 14:42:01 | Re: How to improve the performance of my SQL query？ |
| Previous Message | Tom Lane | 2023-07-24 14:09:06 | Re: Grant all privileges to user on a database |