Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to get Navicat to ONLY show Default PostgreSQL Database

I have successfully connected to my PostgreSQL Database from Navicat Premium. However, when I open the connection I see a ridiculously long list of databases. I only need (and am only able!) to access one of these databases. I have it listed under my Connection Properties as the Default Database, but it doesn't seem to be opening it automatically. I have to right click on the connection, select 'Open Database', and manually enter the database name. Then, if I am working on multiple databases, I have to scroll through thousands of records to find the one I am looking for. It's a pretty terrible inconvenience.

Does anyone know a trick to hide all but the default database for a Navicat connection? I have been Googling the problem and can't find anything helpful. Thanks!

like image 718
TWGerard Avatar asked Mar 18 '23 18:03

TWGerard


1 Answers

In the connection properties, selected the "Advanced" tab. Then check the box to "Use advanced connections". Finally check the box to your database. Done.

I thought I might have to use the "Remove DB from List" but I didn't. After doing the steps above, Navicat only shows my database which is exactly what I wanted.

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

like image 184
BeeZee Avatar answered Mar 25 '23 09:03

BeeZee