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
PostgreSQL - List of schemas in Heidi includes weird entries
See this thread.
I guess I should hide schemata beginning with "pg_", or at least those matching to "^pg_.*temp"
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.