Geek Answers Handbook

How to get Navicat for ONLY show Default PostgreSQL Database

I successfully connected to my PostgreSQL database from Navicat Premium. However, when I open the connection, I see a ridiculously long list of databases. I need (and I can only!) Access one of these databases. I listed it in the "Connection Properties" section as the default database, but it does not seem to open automatically. I have to right-click on the connection, select "Open Database" and manually enter the database name. Then, if I work on several databases, I have to scroll through thousands of records to find the one I'm looking for. This is a pretty terrible inconvenience.

Does anyone know a trick to hide everything except the default database for a Navicat connection? I searched for a problem and did not find anything useful. Thank!

+4
source share
2 answers

In the connection properties, the Advanced tab is selected. Then check the box next to “Use advanced connections.” Finally, check the box in your database. Done.

I thought that I might have to use "Remove DB from List", but I did not. After performing the above steps, Navicat only shows my database, which is exactly what I wanted.

I also have Navicat Premium Essentials (11.1.7); Purchased through the app store.

+7

. . "". " ". . . DB, , " DB "

0

More articles:


All Articles