I have over 100 of these temp schemas.
How can I hide or can I delete them?
In an early stage of PostgreSQL support in Heidi, I had the following query to get the databases (not schemata):
SELECT datname FROM pg_database WHERE datistemplate=FALSE
That query would also filter your temp schemata away, but the whole approach is wrong.
I am wondering where these "temp" schemata come from? What if you delete them?
It seems these pg_temp schemata are auto-created when your application uses temorary tables. And I read that there is roughly 1 schema per simultanous connection. So you can normally delete these, but they're always generated again.
This leads me to the conclusion that HeidiSQL could indeed get some setting for ignoring database names. Or maybe when using the "Databases" setting, that could support regular expression including some negating syntax, like so: "!_temp"
Please login to leave a reply, or register at first.