↑↓ select ↵ open ⌫ change scope Open full search

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

Search PostgreSQL documentation

PG 18 · Browse by category, or enter a name or keyword

Category index16
pg_checkpointPredefined RolesReferencePredefined Roles · Maintenanceallows executing the CHECKPOINT command. pg_checkpoint Maintenance Allow executing the CHECKPOINT command. Name pg_checkpoint Manual terminology Predefined roles pg_create_subscriptionPredefined RolesReferencePredefined Roles · Administrationallows users with CREATE permission on the database to issue CREATE SUBSCRIPTION . pg_create_subscription Administration Allow users with CREATE permission on the database to issue CREATE SU… pg_database_ownerPredefined RolesReferencePredefined Roles · Administrationalways has exactly one implicit member: the current database owner. It cannot be granted membership in any role, and no role can be granted membership in pg_database_owner . However, like an… pg_execute_server_programPredefined RolesReferencePredefined Roles · Server files and programsallows executing programs on the database server as the user the database runs as using COPY and other functions which allow executing a server-side program. pg_execute_server_program Server… pg_maintainPredefined RolesReferencePredefined Roles · Maintenanceallows executing VACUUM , ANALYZE , CLUSTER , REPACK , REFRESH MATERIALIZED VIEW , REINDEX , and LOCK TABLE on all relations, as if having MAINTAIN rights on those objects. pg_maintain Maint… pg_monitorPredefined RolesReferencePredefined Roles · Monitoring and statisticsallows reading/executing various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables . pg_monitor Monitoring and statist… pg_read_all_dataPredefined RolesReferencePredefined Roles · Data accessallows reading all data (tables, views, sequences, large objects), as if having SELECT rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (… pg_read_all_settingsPredefined RolesReferencePredefined Roles · Monitoring and statisticsallows reading all configuration variables, even those normally visible only to superusers. pg_read_all_settings Monitoring and statistics Read all configuration variables, even those normal… pg_read_all_statsPredefined RolesReferencePredefined Roles · Monitoring and statisticsallows reading all pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers. pg_read_all_stats Monitoring and statistics Read all pg_stat… pg_read_server_filesPredefined RolesReferencePredefined Roles · Server files and programsallows reading files from any location the database can access on the server using COPY and other file-access functions. pg_read_server_files Server files and programs Allow reading files fr… pg_signal_autovacuum_workerPredefined RolesReferencePredefined Roles · Processes and connectionsallows signaling autovacuum workers to cancel the current table's vacuum or terminate its session. See Section 9.29.2 . pg_signal_autovacuum_worker Processes and connections pg_signal_autova… pg_signal_backendPredefined RolesReferencePredefined Roles · Processes and connectionsallows signaling another backend to cancel a query or terminate its session. Note that this role does not permit signaling backends owned by a superuser. See Section 9.29.2 . pg_signal_backe… pg_stat_scan_tablesPredefined RolesReferencePredefined Roles · Monitoring and statisticsallows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension). pg_stat_scan_tables Monito… pg_use_reserved_connectionsPredefined RolesReferencePredefined Roles · Processes and connectionsallows use of connection slots reserved via reserved_connections . pg_use_reserved_connections Processes and connections Allow use of connection slots reserved via reserved_connections . Na… pg_write_all_dataPredefined RolesReferencePredefined Roles · Data accessallows writing all data (tables, views, sequences, large objects), as if having INSERT , UPDATE , and DELETE rights on those objects and USAGE rights on all schemas. This role does not bypas… pg_write_server_filesPredefined RolesReferencePredefined Roles · Server files and programsallows writing to files in any location the database can access on the server using COPY and other file-access functions. pg_write_server_files Server files and programs Allow writing to fil…

Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.

Searching every version by default. Manual pages are indexed for PostgreSQL 10–20; the reference library and extension catalogue are not version-bound.

all: every version pg17: one version ex: extensions only ↑↓ select ↵ open