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
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.

answered
0

Postgres 9.1+ can do auto vacuum if set up.

answered