Search PostgreSQL documentation

ALTER TEXT SEARCH PARSERManual ChaptersPG18ALTER TEXT SEARCH PARSER ALTER TEXT SEARCH PARSER — change the definition of a text search parser Synopsis ALTER TEXT SEARCH PARSER name RENAME TO new_name ALTER TEXT SEARCH PARSER name SET …ALTER TEXT SEARCH PARSER ALTER TEXT SEARCH TEMPLATEManual ChaptersPG18ALTER TEXT SEARCH TEMPLATE ALTER TEXT SEARCH TEMPLATE — change the definition of a text search template Synopsis ALTER TEXT SEARCH TEMPLATE name RENAME TO new_name ALTER TEXT SEARCH TEMPLATE…ALTER TEXT SEARCH TEMPLATE ALTER TRIGGERManual ChaptersPG18ALTER TRIGGER ALTER TRIGGER — change the definition of a trigger Synopsis ALTER TRIGGER name ON table_name RENAME TO new_name ALTER TRIGGER name ON table_name [ NO ] DEPENDS ON EXTENSION ext…ALTER TRIGGER ALTER TYPEManual ChaptersPG18ALTER TYPE ALTER TYPE — change the definition of a type Synopsis ALTER TYPE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER TYPE name RENAME TO new_name ALTER …ALTER TYPE ALTER USERManual ChaptersPG18ALTER USER ALTER USER — change a database role Synopsis ALTER USER role_specification [ WITH ] option [ ... ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROL…ALTER USER ALTER USER MAPPINGManual ChaptersPG18ALTER USER MAPPING ALTER USER MAPPING — change the definition of a user mapping Synopsis ALTER USER MAPPING FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | SESSION_USER | PUBLIC } SER…ALTER USER MAPPING ALTER VIEWManual ChaptersPG18ALTER VIEW ALTER VIEW — change the definition of a view Synopsis ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name SET DEFAULT expression ALTER VIEW [ IF EXISTS ] name ALTER [ COLUM…ALTER VIEW amcheck — tools to verify table and index consistencyManual ChaptersPG18F.1. amcheck — tools to verify table and index consistency The amcheck module provides functions that allow you to verify the logical consistency of the structure of relations. The B-Tree ch…amcheck — tools to verify table and index consistency An ExampleManual ChaptersPG1836.16.4. An Example Now that we have seen the ideas, here is the promised example of creating a new operator class. (You can find a working copy of this example in src/tutorial/complex.c and…An Example ANALYZEManual ChaptersPG18ANALYZE ANALYZE — collect statistics about a database Synopsis ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, ...] ] where option can be one of: VERBOSE [ boolean ] SKIP_LOCKED [ bool…ANALYZE ANALYZE Progress ReportingManual ChaptersPG1827.4.1. ANALYZE Progress Reporting Whenever ANALYZE is running, the pg_stat_progress_analyze view will contain a row for each backend that is currently running that command. The tables below…ANALYZE Progress Reporting Anonymous Code BlocksManual ChaptersPG1844.4. Anonymous Code Blocks PL/Python also supports anonymous code blocks called with the DO statement: DO $$ # PL/Python code $$ LANGUAGE plpython3u; An anonymous code block receives no arg…Anonymous Code Blocks Anti-FeaturesManual ChaptersPG1817.3.3.3. Anti-Features The options described in this section allow disabling certain PostgreSQL features that are built by default, but which might need to be turned off if the required sof…Anti-Features Anti-FeaturesManual ChaptersPG1817.4.3.3. Anti-Features -Dreadline={ auto | enabled | disabled } # Allows use of the Readline library (and libedit as well). This option defaults to auto and enables command-line editing and…Anti-Features ANY/SOMEManual ChaptersPG189.24.4. ANY/SOME expression operator ANY (subquery) expression operator SOME (subquery) The right-hand side is a parenthesized subquery, which must return exactly one column. The left-hand e…ANY/SOME ANY/SOME (array)Manual ChaptersPG189.25.3. ANY/SOME (array) expression operator ANY (array expression) expression operator SOME (array expression) The right-hand side is a parenthesized expression, which must yield an array v…ANY/SOME (array) API CompatibilityManual ChaptersPG1836.10.6.2. API Compatibility The API, or application programming interface, is the interface used at compile time.API Compatibility AppendixManual ChaptersPG1841.13.3. Appendix This section contains the code for a set of Oracle-compatible instr functions that you can use to simplify your porting efforts. -- -- instr functions that mimic Oracle's c…Appendix AppendixesManual ChaptersPG18Part VIII. AppendixesAppendixes applicable_rolesManual ChaptersPG1835.5. applicable_roles The view applicable_roles identifies all roles whose privileges the current user can use. This means there is some chain of role grants from the current user to the ro…applicable_roles Application of Multiple PoliciesManual ChaptersPG18Application of Multiple Policies When multiple policies of different command types apply to the same command (for example, SELECT and UPDATE policies applied to an UPDATE command), then the …Application of Multiple Policies Arbitrary Precision NumbersManual ChaptersPG188.1.2. Arbitrary Precision Numbers The type numeric can store numbers with a very large number of digits. It is especially recommended for storing monetary amounts and other quantities where…Arbitrary Precision Numbers Architectural FundamentalsManual ChaptersPG181.2. Architectural Fundamentals Before we proceed, you should understand the basic PostgreSQL system architecture. Understanding how the parts of PostgreSQL interact will make this chapter s…Architectural Fundamentals ArchitectureManual ChaptersPG1829.9. Architecture Logical replication is built with an architecture similar to physical streaming replication (see Section 26.2.5). It is implemented by walsender and apply processes. The w…Architecture Archive CallbackManual ChaptersPG1849.2.3. Archive Callback The archive_file_cb callback is called to archive a single WAL file. typedef bool (*ArchiveFileCB) (ArchiveModuleState *state, const char *file, const char *path); I…Archive Callback Archive Module CallbacksManual ChaptersPG1849.2. Archive Module Callbacks The archive callbacks define the actual archiving behavior of the module. The server will call them as required to process each individual WAL file.Archive Module Callbacks Archive ModulesManual ChaptersPG18Chapter 49. Archive Modules PostgreSQL provides infrastructure to create custom modules for continuous archiving (see Section 25.3). While archiving via a shell command (i.e., archive_comman…Archive Modules Archive RecoveryManual ChaptersPG1819.5.5. Archive Recovery This section describes the settings that apply only for the duration of the recovery. They must be reset for any subsequent recovery you wish to perform. “Recovery” …Archive Recovery archive_command ScriptsManual ChaptersPG1825.3.7.3. archive_command Scripts Many people choose to use scripts to define their archive_command, so that their postgresql.conf entry looks very simple: archive_command = 'local_backup_sc…archive_command Scripts ArchivingManual ChaptersPG1819.5.3. Archiving archive_mode (enum) # When archive_mode is enabled, completed WAL segments are sent to archive storage by setting archive_command or archive_library. In addition to off, to…Archiving ArgumentsManual ChaptersPG18Arguments relname Name of a local relation, for example foo or myschema.mytab. Include double quotes if the name is mixed-case or contains special characters, for example "FooBar"; without q…Arguments ArgumentsManual ChaptersPG18Arguments relname Name of a local relation, for example foo or myschema.mytab. Include double quotes if the name is mixed-case or contains special characters, for example "FooBar"; without q…Arguments ArgumentsManual ChaptersPG18Arguments relname Name of a local relation, for example foo or myschema.mytab. Include double quotes if the name is mixed-case or contains special characters, for example "FooBar"; without q…Arguments ArgumentsManual ChaptersPG18Arguments connname Name of the connection to use.Arguments ArgumentsManual ChaptersPG18Arguments connname Name of the connection to use; omit this parameter to use the unnamed connection. cursorname The name of the cursor to close. fail_on_error If true (the default when omitt…Arguments ArgumentsManual ChaptersPG18Arguments connname The name to use for this connection; if omitted, an unnamed connection is opened, replacing any existing unnamed connection. connstr libpq-style connection info string, fo…Arguments ArgumentsManual ChaptersPG18Arguments connname The name of a named connection to be closed.Arguments ArgumentsManual ChaptersPG18Arguments connname Name of the connection to use.Arguments ArgumentsManual ChaptersPG18Arguments connname Name of the connection to use; omit this parameter to use the unnamed connection. connstr A connection info string, as previously described for dblink_connect. sql The SQL…Arguments ArgumentsManual ChaptersPG18Arguments connname Name of the connection to use; omit this parameter to use the unnamed connection. cursorname The name of the cursor to fetch from. howmany The maximum number of rows to re…Arguments