Re: \d don't print all the tables - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: \d don't print all the tables
Date
Msg-id 20230724141759.g6zr35p6yndkqpox@alvherre.pgsql
Whole thread Raw
In response to Re: \d don't print all the tables  (Ron <ronljohnsonjr@gmail.com>)
List 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/



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Grant all privileges to user on a database
Next
From: jian he
Date:
Subject: Re: How to improve the performance of my SQL query?