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's profile image user_huuser posted 3 months ago in General Permalink

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):
  • shit
user_huuser's profile image user_huuser posted 3 months ago Permalink

how turn off this shit? :-(((

user_huuser's profile image user_huuser posted 3 months ago Permalink

is someone used heidisql with PostgreSQL already? O_O

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.
ansgar's profile image ansgar posted 3 months ago Permalink

Calm down man.

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

Description

ansgar's profile image ansgar posted 3 months ago Permalink

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

user_huuser's profile image user_huuser posted 3 months ago Permalink

ansgar, thanks.

But, i can not find this menu.

Where is it? (11.0.0.5919)

ansgar's profile image ansgar posted 3 months ago Permalink

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

user_huuser's profile image user_huuser posted 3 months ago Permalink

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's profile image user_huuser posted 3 months ago Permalink

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's profile image ansgar posted 3 months ago Permalink

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
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.
user_huuser's profile image user_huuser posted 1 month ago Permalink

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's profile image ansgar posted 1 month ago Permalink

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's profile image user_huuser posted 1 month ago Permalink

Ansgar, thanks.

With -d=yoursession it works.

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

user_huuser's profile image user_huuser posted 1 month ago Permalink

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

user_huuser's profile image user_huuser posted 1 month ago Permalink

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's profile image user_huuser posted 1 month ago Permalink

And 1 more questions:

Have you portable version heidisql ?

ansgar's profile image ansgar posted 1 month ago Permalink

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

Description

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

ansgar's profile image ansgar posted 1 month ago Permalink

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

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




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.