Search PostgreSQL documentation

pg_lsn TypeManual ChaptersPG188.20. pg_lsn Type The pg_lsn data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the WAL. This type is a representation of XLogRecPtr and an int…pg_lsn Type pg_matviewsManual ChaptersPG1853.14. pg_matviews The view pg_matviews provides access to useful information about each materialized view in the database. Table 53.14. pg_matviews Columns Column Type Description schemanam…pg_matviews pg_namespaceManual ChaptersPG1852.32. pg_namespace The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection of relations, types, etc. w…pg_namespace pg_notifyManual ChaptersPG18pg_notify To send a notification you can also use the function pg_notify(text, text). The function takes the channel name as the first argument and the payload as the second. The function is…pg_notify pg_opclassManual ChaptersPG1852.33. pg_opclass The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular data type and a particular inde…pg_opclass pg_operatorManual ChaptersPG1852.34. pg_operator The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information. Table 52.34. pg_operator Columns Column Type Descri…pg_operator pg_opfamilyManual ChaptersPG1852.35. pg_opfamily The catalog pg_opfamily defines operator families. Each operator family is a collection of operators and associated support routines that implement the semantics specified…pg_opfamily pg_overexplain — allow EXPLAIN to dump even more detailsManual ChaptersPG18F.29. pg_overexplain — allow EXPLAIN to dump even more details The pg_overexplain module extends EXPLAIN with new options that provide additional output. It is mostly intended to assist with…pg_overexplain — allow EXPLAIN to dump even more details pg_parameter_aclManual ChaptersPG1852.36. pg_parameter_acl The catalog pg_parameter_acl records configuration parameters for which privileges have been granted to one or more roles. No entry is made for parameters that have d…pg_parameter_acl pg_partitioned_tableManual ChaptersPG1852.37. pg_partitioned_table The catalog pg_partitioned_table stores information about how tables are partitioned. Table 52.37. pg_partitioned_table Columns Column Type Description partrelid …pg_partitioned_table pg_policiesManual ChaptersPG1853.15. pg_policies The view pg_policies provides access to useful information about each row-level security policy in the database. Table 53.15. pg_policies Columns Column Type Description s…pg_policies pg_policyManual ChaptersPG1852.38. pg_policy The catalog pg_policy stores row-level security policies for tables. A policy includes the kind of command that it applies to (possibly all commands), the roles that it appl…pg_policy pg_prepared_statementsManual ChaptersPG1853.16. pg_prepared_statements The pg_prepared_statements view displays all the prepared statements that are available in the current session. See PREPARE for more information about prepared …pg_prepared_statements pg_prepared_xactsManual ChaptersPG1853.17. pg_prepared_xacts The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details). pg_prepare…pg_prepared_xacts pg_prewarm — preload relation data into buffer cachesManual ChaptersPG18F.30. pg_prewarm — preload relation data into buffer caches The pg_prewarm module provides a convenient way to load relation data into either the operating system buffer cache or the Postgre…pg_prewarm — preload relation data into buffer caches pg_procManual ChaptersPG1852.39. pg_proc The catalog pg_proc stores information about functions, procedures, aggregate functions, and window functions (collectively also known as routines). See CREATE FUNCTION, CREAT…pg_proc pg_publicationManual ChaptersPG1852.40. pg_publication The catalog pg_publication contains all publications created in the database. For more on publications see Section 29.1. Table 52.40. pg_publication Columns Column Type…pg_publication pg_publication_namespaceManual ChaptersPG1852.41. pg_publication_namespace The catalog pg_publication_namespace contains the mapping between schemas and publications in the database. This is a many-to-many mapping. Table 52.41. pg_pu…pg_publication_namespace pg_publication_relManual ChaptersPG1852.42. pg_publication_rel The catalog pg_publication_rel contains the mapping between relations and publications in the database. This is a many-to-many mapping. See also Section 53.18 for a…pg_publication_rel pg_publication_tablesManual ChaptersPG1853.18. pg_publication_tables The view pg_publication_tables provides information about the mapping between publications and information of tables they contain. Unlike the underlying catalog …pg_publication_tables pg_rangeManual ChaptersPG1852.43. pg_range The catalog pg_range stores information about range types. This is in addition to the types' entries in pg_type. Table 52.43. pg_range Columns Column Type Description rngtypi…pg_range pg_receivewalManual ChaptersPG18pg_receivewal pg_receivewal — stream write-ahead logs from a PostgreSQL server Synopsis pg_receivewal [option...]pg_receivewal pg_receivexlog renamed to pg_receivewalManual ChaptersPG18O.5. pg_receivexlog renamed to pg_receivewal PostgreSQL 9.6 and below provided a command named pg_receivexlog to fetch write-ahead-log (WAL) files. This command was renamed to pg_receivewal,…pg_receivexlog renamed to pg_receivewal pg_recvlogicalManual ChaptersPG18pg_recvlogical pg_recvlogical — control PostgreSQL logical decoding streams Synopsis pg_recvlogical [option...]pg_recvlogical pg_replication_originManual ChaptersPG1852.44. pg_replication_origin The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 48. Unlike most system catalogs, pg_repli…pg_replication_origin pg_replication_origin_statusManual ChaptersPG1853.19. pg_replication_origin_status The pg_replication_origin_status view contains information about how far replay for a certain origin has progressed. For more on replication origins see C…pg_replication_origin_status pg_replication_slotsManual ChaptersPG1853.20. pg_replication_slots The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state. For more o…pg_replication_slots pg_resetwalManual ChaptersPG18pg_resetwal pg_resetwal — reset the write-ahead log and other control information of a PostgreSQL database cluster Synopsis pg_resetwal [ -f | --force ] [ -n | --dry-run ] [option...] [ -D |…pg_resetwal pg_resetxlog renamed to pg_resetwalManual ChaptersPG18O.4. pg_resetxlog renamed to pg_resetwal PostgreSQL 9.6 and below provided a command named pg_resetxlog to reset the write-ahead-log (WAL) files. This command was renamed to pg_resetwal, see…pg_resetxlog renamed to pg_resetwal pg_restoreManual ChaptersPG18pg_restore pg_restore — restore a PostgreSQL database from an archive file created by pg_dump Synopsis pg_restore [connection-option...] [option...] [filename]pg_restore pg_rewindManual ChaptersPG18pg_rewind pg_rewind — synchronize a PostgreSQL data directory with another data directory that was forked from it Synopsis pg_rewind [option...] { -D | --target-pgdata } directory { --source…pg_rewind pg_rewriteManual ChaptersPG1852.45. pg_rewrite The catalog pg_rewrite stores rewrite rules for tables and views. Table 52.45. pg_rewrite Columns Column Type Description oid oid Row identifier rulename name Rule name ev_…pg_rewrite pg_rolesManual ChaptersPG1853.21. pg_roles The view pg_roles provides access to information about database roles. This is simply a publicly readable view of pg_authid that blanks out the password field. Table 53.21. p…pg_roles pg_rulesManual ChaptersPG1853.22. pg_rules The view pg_rules provides access to useful information about query rewrite rules. Table 53.22. pg_rules Columns Column Type Description schemaname name (references pg_namesp…pg_rules pg_seclabelManual ChaptersPG1852.46. pg_seclabel The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to view security …pg_seclabel pg_seclabelsManual ChaptersPG1853.23. pg_seclabels The view pg_seclabels provides information about security labels. It as an easier-to-query version of the pg_seclabel catalog. Table 53.23. pg_seclabels Columns Column Ty…pg_seclabels pg_sequenceManual ChaptersPG1852.47. pg_sequence The catalog pg_sequence contains information about sequences. Some of the information about sequences, such as the name and the schema, is in pg_class Table 52.47. pg_sequ…pg_sequence pg_sequencesManual ChaptersPG1853.24. pg_sequences The view pg_sequences provides access to useful information about each sequence in the database. Table 53.24. pg_sequences Columns Column Type Description schemaname name…pg_sequences pg_settingsManual ChaptersPG1853.25. pg_settings The view pg_settings provides access to run-time parameters of the server. It is essentially an alternative interface to the SHOW and SET commands. It also provides access…pg_settings pg_shadowManual ChaptersPG1853.26. pg_shadow The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1. It shows properties of all roles that are marked …pg_shadow