#3577 Don`t show database list for PostgreSQL

[Anonymous]

Originally created by: Karen.Ar...@gmail.com

What exact steps will reproduce the problem?
1.Connect to PosgreSQL server without set database name into connection dialog.
2.Don`t show database list.
3.Show only shema list.

Version used?
Build: 4784

Please see to screenshot.

[Anonymous]

Originally posted by: a...@anse.de

See issue #3190. PostgreSQL does not allow to "USE somedbname". Instead, in PostgreSQL, you must pass one database name into the connection, and then work with that database until you connect a second time. HeidiSQL uses exactly one connection, and I guess if Navicat supports that it opens up several connections, one for each database you expand. That's not what HeidiSQL aims to do.

Mergedinto: 3190
Status: Duplicate

[Anonymous]

Originally posted by: Karen.Ar...@gmail.com

I think navikat not open many connections to all databases. More than that the properties of the connection to the database I do not specify the name of the database to which I want to connect. Navikat itself displays a list of existing database on the server. That's what I'm talking about.

[Anonymous]

Originally posted by: a...@anse.de

Navicat must do that internally, and does not show you the number of internal sessions it has opened in the end. The C API of PostgreSQL only allows to pass *one* database name to a new connection. Afterwards, you cannot change the selected database, like you do in MySQL with a "USE otherdb". In PostgreSQL there is no way to do that. So, a client has to open up one session per database.