OQL on Catalog pg_catalog instead of Schema public in Postgres in the Mendix cloud
2
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.
asked
Ivo Sturm
2 answers
2
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.