Re: Pgadmin 4 schema visibility

Murtuza Zabuawala <[email protected]>
Newsgroups gmane.comp.db.postgresql.general
Message-ID <CAKKotZRkDuYEVKSHZhMFjHoiStfkO_6WR4CAyNuhoP9k2jFp-A@mail.gmail.com>
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 <[email protected]> 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.
> [image: namespace.jpg]
> [image: dn.PNG]
> [image: pgadmin4.PNG]
> Can anyone explain why is this so? Does anyone have a solution for this?
>
> Thank you
>
>
>
dn.PNG (image/png, 12.4 KB) - not displayed
namespace.jpg (image/jpeg, 233.8 KB) - not displayed
pgadmin4.PNG (image/png, 30.2 KB) - not displayed
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.