OQL on Catalog pg_catalog instead of Schema public in Postgres in the Mendix cloud
Does anybody know whether it is possible to use an OQL java action (using Core.retrieveOQLDataTable or similar) while accessing the Catalog 'pg_catalog' instead of the Schema 'public'. The reason for this is I want to be able to check whether the postgreSQL Database has a lot of tuplets and needs vacuum or a restore.
No, it's not. OQL only works on Mendix enities. Tables in the pg_catalog schema are unknown to Mendix, and cannot be used in OQL.