PostgreSQL database not available via Navicat
I'm new to Postgres, not SQL. I usually use Navicat to connect to my databases, so I set up a remote Postgres DB connection just like I normally would. I can:
- Connect successfully
- Database list
However, when I click on the database with my tables, it expands the database but shows nothing. There are no tables.
I saw another question here where the user was trying to get into "template0" and "template1": Some PostgreSQL databases are not visible through clients like Navicat or pgAdmin
I am not trying to penetrate them, but a special database full of tables. I have verified that both my web app and phpPgAdmin can access all tables and data, so the problem seems to be Navicat related.
I read a few instructions on how these tables can be "system items" and went into Navicat settings and checked the "Show system items (PostgreSQL, SQL Server)" checkbox to no avail.
One thing I have also tried, since I am using Navicat Premium, is to install the Navicat PostgreSQL version. This also gives exactly the same results, I can see my database, but none of the tables.
What's going on here?
EDIT
With a lot of help from Vao Tsun, we have determined that this is PostgreSQL 7.2.4 and that it is not supported by Navicat.
source to share
https://www.navicat.com/products/navicat-for-postgresql :
Navicat for PostgreSQL connects you to any local / remote PostgreSQL database servers from version 7.3 or higher.
It doesn't work with PostgreSQL 7.2.4
source to share