PostgreSql - search_path

Hi!

Heidi changes search_path when I click on schema. Is it possible to set up search_path value for every schema in DB? F.e. I would like to have:

set search_path = "$user", public

insead of

regards

What exactly means $user in this case?

If that makes sense for everyone I would of course change that command in HeidiSQL.

Schema "$user" means schema with the same name as user name. It is seached at first, then public schema. In the application I use I have many schemas and some global functions are not availeble in default HeidiSql behavior. But I added this command to startup script and my issue has ben solved.

So I guess I get it right if I say $user is useful for all other users as well. I should change that search path command in the base HeidiSQL code.

Next build should have that.

Thanks! My problem has ben solved. Current behavior may be interesting for others. I think It could be an option.