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