↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Predefined Roles

pg_maintain

pg_maintain allows executing VACUUM , ANALYZE , CLUSTER , REFRESH MATERIALIZED VIEW , REINDEX , and LOCK TABLE on all relations, as if having MAINTAIN rights on those objects.

Reading PG 18·Select a recorded version

Name
pg_maintain
Manual terminology
Predefined roles

Definition PG 18

pg_maintain allows executing VACUUM , ANALYZE , CLUSTER , REFRESH MATERIALIZED VIEW , REINDEX , and LOCK TABLE on all relations, as if having MAINTAIN rights on those objects.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75

Text language: en · b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75