Re: \d don't print all the tables

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: \d don't print all the tables
Date: 2023-07-24 13:42:27
Message-ID: add301c0-ecd4-2f01-af5e-4e9f4ee1a9ef@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/23/23 19:25, Wen Yi wrote:
> Hi community,
> here's my shell:

> I think it should print the table on namespace_a & namespace_b, not just
> public, it really confused me.
> Can someone give me some advice?

Read about search_path:

https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH

>
> Yours,
> Wen Yi.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2023-07-24 13:56:28 Re: Grant all privileges to user on a database
Previous Message Kaushal Shriyan 2023-07-24 13:38:24 Re: Grant all privileges to user on a database