[Squirrel-sql-users] Postgresql information_schema system tables and views - unknown type

[Alex M. <ale...@bl...>]

Currently I am working with the 9.6 server under FreeBSD 11.1 via the 42.1.4 JDBC driver. When I look at the tables and views under information_schema schema through the Squirrel Content tab, all values of all columns in all of those tables and views without exception come across as <UnknownType (2,001)>. Is this expected, or is anything wrong in my configuration?

All driver and alias properties are the default values. This is the connection string just in case: jdbc:postgresql://10.1.1.144:5432/testdb

Thank you!
Alex

[cid:image001.png@01D30C5A.01780870]
[cid:image002.png@01D30C5A.01780870]
[cid:image003.png@01D30C5A.01780870]