heidisql does not work correctly with PostgreSQL (pg_temp_1, pg_temp_2 .... pg_temp_100500)

Hello

heidisql does not work correctly with PostgreSQL

Its to much unusefull information: (pg_temp_1, pg_temp_2 .... pg_temp_100500)

How can I turn it OFF FOREVER?

how turn off this shit? :-(((

is someone used heidisql with PostgreSQL already? O_O

Calm down man.

You can filter away whatever databases you want, using the "hide database pattern" in the advanced session settings:

You will need the latest build to get that new setting.

ansgar, thanks.

But, i can not find this menu.

Where is it? (11.0.0.5919)

See my second comment. Just update to the latest build, in Help > Check for updates.

Ansgar, Thank You. Version 5989 has this filter, as you said.

But I have two questions:

1. How can I exclude both pg_temp_% and pg_toast_temp_%? Filter ^pg_temp_\d,^pg_toast_temp_\d does not work.

And second question:

How can I save this filter for start heidisql by CMD in windows?

We have some computers and we want to connect by heidisql to different databases. Settings of connections are transfer by CMD parameters. Can I set filter by CMD start parameters?

Try this one: pg_(toast_)?temp

Or, more exact: ^pg_(toast_)?temp$

For the command line question: you can pass some of the parameters per command line, but only the most important ones. See the help section for details. That filter setting cannot be passed via command line. But you could store a session under a name "mysess" and just pass the session name instead:

path\to\heidisql.exe -d=mysess

Ansgar, can you turn off "to show pg_temp" ?

For example, when I start heidisql by cmd:

heidisql.exe -h 192.168.0.1 -u postgres -p password -db mydb -P 5432 -l libpq-12.dll -n 8

I can not to turn off this.

I want to connect to different servers by start heidisql via cmd with connect parametres.

Or theare is some method to save ^pg(toast)?temp$ filter then I connect to many many different servers?

The code I wrote for parsing the command line should allow you to pass a basic session name via -d=yoursession, which you can create in the session manager, with e.g. your database filter setting. Then, on the command line you can e.g. pass additional stuff like the ip address or the user name which may differ from the one in the session.

Ansgar, thanks.

With -d=yoursession it works.

Can I save file "yoursession" and use it in another computer?

I can't find file "yoursession*" after create "yoursession" in interface. :-(

And can I group tables, functions etc ?

Their are together now:

func1 func2 func3 ... tab1 tab2 tab3

Can I do like this:

functions func1 func2 func3

tables tab1 tab2 tab3

And 1 more questions:

Have you portable version heidisql ?

"yoursession" was just an example. You have to create your own one, and take the name from the tree for that -d parameter:

And yes, there is a portable version on the download page.

And yes, you can group object types in the database tree. See the help section for how that works.