Search PostgreSQL documentation

pg_tablespaceManual ChaptersPG1852.56. pg_tablespace The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration of disk layout. Unlike…pg_tablespace pg_test_fsyncManual ChaptersPG18pg_test_fsync pg_test_fsync — determine fastest wal_sync_method for PostgreSQL Synopsis pg_test_fsync [option...]pg_test_fsync pg_test_timingManual ChaptersPG18pg_test_timing pg_test_timing — measure timing overhead Synopsis pg_test_timing [option...]pg_test_timing pg_timezone_abbrevsManual ChaptersPG1853.33. pg_timezone_abbrevs The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents of this view cha…pg_timezone_abbrevs pg_timezone_namesManual ChaptersPG1853.34. pg_timezone_names The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their associated abbreviations, UTC offsets, and daylig…pg_timezone_names pg_transformManual ChaptersPG1852.57. pg_transform The catalog pg_transform stores information about transforms, which are a mechanism to adapt data types to procedural languages. See CREATE TRANSFORM for more information…pg_transform pg_trgm — support for similarity of text using trigram matchingManual ChaptersPG18F.35. pg_trgm — support for similarity of text using trigram matching The pg_trgm module provides functions and operators for determining the similarity of alphanumeric text based on trigram…pg_trgm — support for similarity of text using trigram matching pg_triggerManual ChaptersPG1852.58. pg_trigger The catalog pg_trigger stores triggers on tables and views. See CREATE TRIGGER for more information. Table 52.58. pg_trigger Columns Column Type Description oid oid Row ide…pg_trigger pg_ts_configManual ChaptersPG1852.59. pg_ts_config The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser and a list of dictionaries to…pg_ts_config pg_ts_config_mapManual ChaptersPG1852.60. pg_ts_config_map The pg_ts_config_map catalog contains entries showing which text search dictionaries should be consulted, and in what order, for each output token type of each text s…pg_ts_config_map pg_ts_dictManual ChaptersPG1852.61. pg_ts_dict The pg_ts_dict catalog contains entries defining text search dictionaries. A dictionary depends on a text search template, which specifies all the implementation functions …pg_ts_dict pg_ts_parserManual ChaptersPG1852.62. pg_ts_parser The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning a token type to each l…pg_ts_parser pg_ts_templateManual ChaptersPG1852.63. pg_ts_template The pg_ts_template catalog contains entries defining text search templates. A template is the implementation skeleton for a class of text search dictionaries. Since a t…pg_ts_template pg_typeManual ChaptersPG1852.64. pg_type The catalog pg_type stores information about data types. Base types and enum types (scalar types) are created with CREATE TYPE, and domains with CREATE DOMAIN. A composite typ…pg_type pg_upgradeManual ChaptersPG18pg_upgrade pg_upgrade — upgrade a PostgreSQL server instance Synopsis pg_upgrade -b oldbindir [-B newbindir] -d oldconfigdir -D newconfigdir [option...]pg_upgrade pg_upgradeManual ChaptersPG18E.6.3.7.2. pg_upgrade Allow pg_upgrade to preserve optimizer statistics (Corey Huinker, Jeff Davis, Nathan Bossart) § § § § Extended statistics are not preserved. Also add pg_upgrade option …pg_upgrade pg_userManual ChaptersPG1853.35. pg_user The view pg_user provides access to information about database users. This is simply a publicly readable view of pg_shadow that blanks out the password field. Table 53.35. pg_…pg_user pg_user_mappingManual ChaptersPG1852.65. pg_user_mapping The catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view pg_user_mappings instea…pg_user_mapping pg_user_mappingsManual ChaptersPG1853.36. pg_user_mappings The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of pg_user_mapping that leaves out the opti…pg_user_mappings pg_verifybackupManual ChaptersPG18pg_verifybackup pg_verifybackup — verify the integrity of a base backup of a PostgreSQL cluster Synopsis pg_verifybackup [option...]pg_verifybackup pg_viewsManual ChaptersPG1853.37. pg_views The view pg_views provides access to useful information about each view in the database. Table 53.37. pg_views Columns Column Type Description schemaname name (references pg_…pg_views pg_visibility — visibility map information and utilitiesManual ChaptersPG18F.36. pg_visibility — visibility map information and utilities The pg_visibility module provides a means for examining the visibility map (VM) and page-level visibility information of a tabl…pg_visibility — visibility map information and utilities pg_wait_eventsManual ChaptersPG1853.38. pg_wait_events The view pg_wait_events provides description about the wait events. Table 53.38. pg_wait_events Columns Column Type Description type text Wait event type name text Wait…pg_wait_events pg_waldumpManual ChaptersPG18pg_waldump pg_waldump — display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster Synopsis pg_waldump [option...] [startseg [endseg]]pg_waldump pg_walinspect — low-level WAL inspectionManual ChaptersPG18F.37. pg_walinspect — low-level WAL inspection The pg_walinspect module provides SQL functions that allow you to inspect the contents of write-ahead log of a running PostgreSQL database clus…pg_walinspect — low-level WAL inspection pg_walsummaryManual ChaptersPG18pg_walsummary pg_walsummary — print contents of WAL summary files Synopsis pg_walsummary [option...] [file...]pg_walsummary pg_xlogdump renamed to pg_waldumpManual ChaptersPG18O.3. pg_xlogdump renamed to pg_waldump PostgreSQL 9.6 and below provided a command named pg_xlogdump to read write-ahead-log (WAL) files. This command was renamed to pg_waldump, see pg_waldu…pg_xlogdump renamed to pg_waldump pgbenchManual ChaptersPG18pgbench pgbench — run a benchmark test on PostgreSQL Synopsis pgbench -i [option...] [dbname] pgbench [option...] [dbname]pgbench pgcryptoManual ChaptersPG18E.6.3.9.2. pgcrypto Add pgcrypto algorithms sha256crypt and sha512crypt (Bernd Helmle) § Add CFB mode to pgcrypto encryption and decryption (Umar Hayat) § Add function fips_mode() to report …pgcrypto pgcrypto — cryptographic functionsManual ChaptersPG18F.26. pgcrypto — cryptographic functions The pgcrypto module provides cryptographic functions for PostgreSQL. This module is considered “trusted”, that is, it can be installed by non-superus…pgcrypto — cryptographic functions PGP Encryption FunctionsManual ChaptersPG18F.26.3. PGP Encryption Functions The functions here implement the encryption part of the OpenPGP (RFC 4880) standard. Supported are both symmetric-key and public-key encryption. An encrypted…PGP Encryption Functions pgp_armor_headersManual ChaptersPG18F.26.3.7. pgp_armor_headers pgp_armor_headers(data text, key out text, value out text) returns setof record pgp_armor_headers() extracts the armor headers from data. The return value is a se…pgp_armor_headers pgp_key_id()Manual ChaptersPG18F.26.3.5. pgp_key_id() pgp_key_id(bytea) returns text pgp_key_id extracts the key ID of a PGP public or secret key. Or it gives the key ID that was used for encrypting the data, if given an …pgp_key_id() pgp_pub_decrypt()Manual ChaptersPG18F.26.3.4. pgp_pub_decrypt() pgp_pub_decrypt(msg bytea, key bytea [, psw text [, options text ]]) returns text pgp_pub_decrypt_bytea(msg bytea, key bytea [, psw text [, options text ]]) retur…pgp_pub_decrypt() pgp_pub_encrypt()Manual ChaptersPG18F.26.3.3. pgp_pub_encrypt() pgp_pub_encrypt(data text, key bytea [, options text ]) returns bytea pgp_pub_encrypt_bytea(data bytea, key bytea [, options text ]) returns bytea Encrypt data wi…pgp_pub_encrypt() pgp_sym_decrypt()Manual ChaptersPG18F.26.3.2. pgp_sym_decrypt() pgp_sym_decrypt(msg bytea, psw text [, options text ]) returns text pgp_sym_decrypt_bytea(msg bytea, psw text [, options text ]) returns bytea Decrypt a symmetric…pgp_sym_decrypt() pgp_sym_encrypt()Manual ChaptersPG18F.26.3.1. pgp_sym_encrypt() pgp_sym_encrypt(data text, psw text [, options text ]) returns bytea pgp_sym_encrypt_bytea(data bytea, psw text [, options text ]) returns bytea Encrypt data with…pgp_sym_encrypt() pgrowlocks — show a table's row locking informationManual ChaptersPG18F.31. pgrowlocks — show a table's row locking information The pgrowlocks module provides a function to show row locking information for a specified table. By default use is restricted to sup…pgrowlocks — show a table's row locking information pgstattuple — obtain tuple-level statisticsManual ChaptersPG18F.33. pgstattuple — obtain tuple-level statistics The pgstattuple module provides various functions to obtain tuple-level statistics. Because these functions return detailed page-level infor…pgstattuple — obtain tuple-level statistics pgtypes LibraryManual ChaptersPG1834.6. pgtypes Library The pgtypes library maps PostgreSQL database types to C equivalents that can be used in C programs. It also offers functions to do basic calculations with those types w…pgtypes Library