Postgres Pro
Downloads
Home   >   mailing lists

Re: Pgadmin 4 schema visibility - Mailing list pgsql-general

From Murtuza Zabuawala
Subject Re: Pgadmin 4 schema visibility
Date
Msg-id CAKKotZRkDuYEVKSHZhMFjHoiStfkO_6WR4CAyNuhoP9k2jFp-A@mail.gmail.com
Whole thread Raw
In response to Pgadmin 4 schema visibility  (Jill Jade <jill779ks@gmail.com>)
Responses Re: Pgadmin 4 schema visibility
List pgsql-general
Tree view
Hi, 

You can configure pgAdmin4 to hide/show system objects.
Goto File menu -> Preferences -> Browser -> Display -> Show system objects? 

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



On Mon, Nov 25, 2019 at 3:19 PM Jill Jade <jill779ks@gmail.com> wrote:
Hello everyone,

I am using Postgres 11 with Pgadmin4. System schemas pg_temp and pg_toast are not visible when I do \dn+ in psql. 

But when I do SELECT nspname FROM pg_catalog.pg_namespace;, I see the schemas.
namespace.jpg
dn.PNG
pgadmin4.PNG
Can anyone explain why is this so? Does anyone have a solution for this?

Thank you


Attachment

pgsql-general by date:

Previous
From: "Zwettler Markus (OIZ)"
Date:
Subject: AW: sql query for postgres replication check
Next
From: Jill Jade
Date:
Subject: Re: Pgadmin 4 schema visibility