PostgreSQL - List of schemas in Heidi includes weird entries

[expired user #9074]'s profile image [expired user #9074] posted 9 years ago in General Permalink
I don't know exactly why this is, but in HeidiSQL the list of schemas includes a lot of weird temporary schemas that I don't see in pgAdmin. I can see in the log what query Heidi used to get the schema list:
SELECT "nspname" FROM "pg_catalog"."pg_namespace" ORDER BY "nspname";

This does seem to work better than the other suggestion I've seen online, which is:
select catalog_name, schema_name from information_schema.schemata
(this only returns one schema when I run it)

See the attached screenshots, though, to see the schemas listed in pgAdmin instead of those listed in Heidi. Again, I don't have the expertise to suggest whether this is good or bad, or what to do about it.

Nate
2 attachment(s):
  • schemas_pgadmin
  • schemas_hedisql
ansgar's profile image ansgar posted 9 years ago Permalink
See this thread.

I guess I should hide schemata beginning with "pg_", or at least those matching to "^pg_.*temp"

Please login to leave a reply, or register at first.