[This topic is migrated from our old forums. The original author name has been removed]
Hi,
In demo version of dbvisualizer, when i connect to a database. I can see all database on the postgres server not only the one in URL. The other database (not referenced in url) are not accessible but visible
If i use the full version, i can only see the database referenced in url.
Can you mix this two behavior, see all database in full version and list object if i have the good credential on it.
It's boring to create for every database a connection ;).
Thank you
Bart,
This is something that we are looking into. It will however not make its way into the upcoming 9.2 version.
Maybe in a 9.2.x version released soon after. 9.2 is planned in a few weeks.
Regards
Roger
a
anonymous
said
over 9 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Show all Db in postgresql
Hi,
I really hope listing all db's that are available to the connection makes it soon to a release.
It is the only thing keeping me from renewing my license.
It is very annoying having to define each and every db manually.
It is the only software I know having this way of working.
We looked at Navicat, VStudio,... which all list all db's of a server. So it does not look like it is a postgresql problem...
Regards and hoping...
Roger Bjärevall
said
over 10 years ago
[This reply is migrated from our old forums.]
Re: Show all Db in postgresql
Jonas,
Thanks for the reply.
Great to see your ideas match our own ideas quite well.
Regards
Roger
a
anonymous
said
over 10 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Show all Db in postgresql
Even though quering multiple databases is not possible in postgres it would be nice to adjust the browsing tree accorging to the behaviour in postgresql and the jdbc driver.
Either implement multi-database support per in one connection perhaps a bit like in pgadmin or
drop the database level in the tree altogether, like it is for eg oracle or mysql.
In the first case you would need to define one 'maintanance database' (defaulting to 'postgres') which would be used to query what other databases are available.
Roger Bjärevall
said
over 10 years ago
[This reply is migrated from our old forums.]
Re: Show all Db in postgresql
Hi,
This is a limitation of PostgreSQL. We do have an open ticket so that DbVisualizer implicitly open an additional connection when browsing other databases. This is not scheduled as of now.
Read more in the PostgreSQL FAQ:
http://wiki.postgresql.org/wiki/FAQ#How_do_I_perform_queries_using_multiple_databases.3F
Regards
Roger
a
anonymous
said
over 10 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Show all Db in postgresql
I'm also dismayed by the lack of this feature. We have tens of databases, each with their own schemas. We never had a problem in Oracle, so it seems strange to have such a limitation in Postgres.
Roger, is there a way to remove this limitation from the DB server config files?
Roger Bjärevall
said
over 11 years ago
[This reply is migrated from our old forums.]
Re: Show all Db in postgresql
Bertrand,
I will add your vote for improving multi database support for PostgreSQL. (The current limitation is due to restrictions in PostgreSQL that don't allow accessing other databases than the default).
Regards
Roger
anonymous