Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

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

user_huuser posted 12 months ago in General

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?

1 attachment(s):
user_huuser posted 12 months ago

how turn off this shit? :-(((

user_huuser posted 12 months ago

is someone used heidisql with PostgreSQL already? O_O

ansgar posted 12 months ago

Calm down man.

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

ansgar posted 12 months ago

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

user_huuser posted 12 months ago

ansgar, thanks.

But, i can not find this menu.

Where is it? (11.0.0.5919)

ansgar posted 12 months ago

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

user_huuser posted 11 months ago

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.
user_huuser posted 11 months ago

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?

ansgar posted 11 months ago

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 user_huuser posted 10 months ago 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?

ansgar posted 10 months ago

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.

user_huuser posted 10 months ago

Ansgar, thanks.

With -d=yoursession it works.

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

user_huuser posted 10 months ago

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

user_huuser posted 10 months ago

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

user_huuser posted 10 months ago

And 1 more questions:

Have you portable version heidisql ?

ansgar posted 10 months ago

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