Tables not Listed for Older Versions of PostgreSQL

Toad Edge
1

I am working on an archival project and need to access an old version 9.3 PostgreSQL server. I can successfully connect and query the database, however, many of the database objects are not listed in the Object Explorer. Objects that are listed include sequences, indexes, and constraints. However, other objects such as tables do not.

Toad Edge version 2.11.0.202407081033
PostgreSQL JDBC driver version 42.7

2

Note, the following statement executed in a Toad Edge SQL Editor correctly lists the tables:

SELECT * FROM information_schema.tables WHERE table_schema = 'public';

3

Hi,
Just some background, that Toad Edge never officially supported PostgreSQL version 9.3 in the past, the earliest supported version was I believe 9.4. Toad defaults to the latest available PostgreSQL version (16) when working with unsupported versions. And there's a significant version gap between 9.3 and 16 creating compatibility issues that I doubt can be resolved with workarounds.

4

Thanks. As I suspected.

Most of my work is with the more current version 14 of PostgreSQL. Accessing a 9.3 server was for a project archiving an old system. Toad Edge works well enough with 9.3 to get the work done. I was just wondering if there was something I could do that I was missing.

Thanks again,
Michael

1 Like