Pgadmin 4 schema visibility

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Pgadmin 4 schema visibility

Jill Jade
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


Reply | Threaded
Open this post in threaded view
|

Re: Pgadmin 4 schema visibility

Murtuza Zabuawala
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 <[hidden email]> 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


Reply | Threaded
Open this post in threaded view
|

Re: Pgadmin 4 schema visibility

Jill Jade
Hello,

I have done this step, and still the problem is persisting. Do you have any other solution?

Thank you

On Mon, 25 Nov 2019 at 14:52, Murtuza Zabuawala <[hidden email]> wrote:
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 <[hidden email]> 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


Reply | Threaded
Open this post in threaded view
|

Re: Pgadmin 4 schema visibility

Adrian Klaver-4
In reply to this post by Jill Jade
On 11/24/19 11:55 PM, Jill Jade 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?

\dnS+:

https://www.postgresql.org/docs/11/app-psql.html

\dn[S+] [ pattern ]

     Lists schemas (namespaces). If pattern is specified, only schemas
whose names match the pattern are listed. By default, only user-created
objects are shown; supply a pattern or the S modifier to include system
objects. If + is appended to the command name, each object is listed
with its associated permissions and description, if any.


>
> Thank you
>
>


--
Adrian Klaver
[hidden email]