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!
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With