It seems there is some issue between Ignition and PostgreSQL involving uppercase table names. If I create a table named “TESTdata” and do a database browse in ignition, I will get an error stating there is no relation “testdata”. The easy workaround is just to not use capital letters in table names, but it would be nice to not have to do this.
example: SELECT * FROM “TESTdata”
I had sort of the same issue when migrating to a new MySQL database. It used to be case agnostic, but it appears that’s no longer the case (Doh! Pun was not intended, but I’m going to keep it anyway).