Search PostgreSQL documentation

external_fileExtensionsExtensionsAccess external server-side files through PostgreSQL functions external_file UtilitiesUtilities · Extensions external_pid_fileConfigurationReferenceexternal_pid_file File Locations 10 Specifies the name of an additional process-ID (PID) file that the server should create for use by server administration programs. This parameter can only…Configuration · File Locations external_search_fdwExtensionsExtensionsAlloyDB extension that provides a read-only foreign data wrapper for querying Elasticsearch data from PostgreSQL. alloydb elasticsearch fdw search external_search_fdw Foreign data wrappersForeign data wrappers · Extensions Extra TestsManual ChaptersPG1831.1.6. Extra Tests The core regression test suite contains a few test files that are not run by default, because they might be platform-dependent or take a very long time to run. You can ru…Extra Tests extra_float_digitsConfigurationReferenceextra_float_digits Client Connection Defaults 10 This parameter adjusts the number of digits displayed for floating-point values, including float4, float8, and geometric data types. The para…Configuration · Client Connection Defaults extra_window_functionsExtensionsExtensionsExtra Window Functions for PostgreSQL extra_window_functions Functions and aggregatesFunctions and aggregates · Extensions extractFunctionsReferenceextract Date/Time Functions And Operators 10 Get subfield; see Section 9.9.1 extract ( field from timestamp ) → double precision Get subfield; see Section 9.9.1 extract ( field from interval…Functions · Date/Time Functions And Operators EXTRACT, date_partManual ChaptersPG189.9.1. EXTRACT, date_part EXTRACT(field FROM source) The extract function retrieves subfields such as year or hour from date/time values. source must be a value expression of type timestamp,…EXTRACT, date_part extremaExtensionsExtensionsPostgreSQL extension to control resource usage of other extensions' bgworkers extrema AdministrationAdministration · Extensions F0000SQLSTATEReferenceF0000 Class F0 · Configuration File Error 10 config_file_error 11 12 13 14 15 16 17 18 19 20 9.0 9.1 9.2 9.3 9.4 9.5 9.6 # F0000 ## At a glance {#at-a-glance} `F0000` is the configuration-…SQLSTATE · Class F0 · Configuration File Error F0001SQLSTATEReferenceF0001 Class F0 · Configuration File Error 10 lock_file_exists 11 12 13 14 15 16 17 18 19 20 9.0 9.1 9.2 9.3 9.4 9.5 9.6 # F0001 ## At a glance {#at-a-glance} `F0001` is a startup ownership…SQLSTATE · Class F0 · Configuration File Error factorialFunctionsReferencefactorial Mathematical Functions And Operators 10 factorial ( bigint ) → numeric factorial 11 12 13 Factorial factorial ( bigint ) → numeric Factorial 14 15 16 17 18 19 20 9.5 9.6Functions · Mathematical Functions And Operators FailoverManual ChaptersPG1826.3. Failover If the primary server fails then the standby server should begin failover procedures. If the standby server fails then no failover need take place. If the standby server can b…Failover Failures and Serialization/Deadlock RetriesManual ChaptersPG18Failures and Serialization/Deadlock Retries When executing pgbench, there are three main types of errors: Errors of the main program. They are the most serious and always result in an immedi…Failures and Serialization/Deadlock Retries fakerExtensionsExtensionsWrapper for the Faker Python library test faker Procedural languagesProcedural languages · Extensions fakesetExtensionsExtensionspostgres extension to generate fake sentences fakeset Functions and aggregatesFunctions and aggregates · Extensions falconExtensionsExtensionsFalconFS is a high-performance distributed file system (DFS) designed for AI workloads. falcon AnalyticsAnalytics · Extensions fallback_application_nameCommand-line ToolsPG18fallback_application_name Specifies a fallback value for the application_name configuration parameter. This value will be used if no value has been given for application_name via a connectio…Database Connection Control Functions › Parameter Key Words familyFunctionsReferencefamily Network Address Functions And Operators 10 extract family of address; 4 for IPv4, 6 for IPv6 family ( inet ) → int extract family of address; 4 for IPv4, 6 for IPv6 11 12 13 Returns t…Functions · Network Address Functions And Operators fast_guidExtensionsExtensionsFast GUID generator function for PostgreSQL. postgresql_fast_guid Functions and aggregatesFunctions and aggregates · Extensions fasttrunExtensionsExtensionsOptimezed fasttruncate extension for 1C:Enterprise 8 fasttrun AdministrationAdministration · Extensions fbsqlExtensionsExtensionsClosure-preserving formula-based statistical modeling in SQL statistics glm machine-learning plr fbsql Functions and aggregatesFunctions and aggregates · Extensions FDW Options of postgres_fdwManual ChaptersPG18F.38.1. FDW Options of postgres_fdwFDW Options of postgres_fdw FDW Routines for ANALYZEManual ChaptersPG1858.2.8. FDW Routines for ANALYZE bool AnalyzeForeignTable(Relation relation, AcquireSampleRowsFunc *func, BlockNumber *totalpages); This function is called when ANALYZE is executed on a fore…FDW Routines for ANALYZE FDW Routines for Asynchronous ExecutionManual ChaptersPG1858.2.11. FDW Routines for Asynchronous Execution A ForeignScan node can, optionally, support asynchronous execution as described in src/backend/executor/README. The following functions are a…FDW Routines for Asynchronous Execution FDW Routines for EXPLAINManual ChaptersPG1858.2.7. FDW Routines for EXPLAIN void ExplainForeignScan(ForeignScanState *node, ExplainState *es); Print additional EXPLAIN output for a foreign table scan. This function can call ExplainPr…FDW Routines for EXPLAIN FDW Routines for IMPORT FOREIGN SCHEMAManual ChaptersPG1858.2.9. FDW Routines for IMPORT FOREIGN SCHEMA List * ImportForeignSchema(ImportForeignSchemaStmt *stmt, Oid serverOid); Obtain a list of foreign table creation commands. This function is ca…FDW Routines for IMPORT FOREIGN SCHEMA FDW Routines for Parallel ExecutionManual ChaptersPG1858.2.10. FDW Routines for Parallel Execution A ForeignScan node can, optionally, support parallel execution. A parallel ForeignScan will be executed in multiple processes and must return eac…FDW Routines for Parallel Execution FDW Routines for Planning Post-Scan/Join ProcessingManual ChaptersPG1858.2.3. FDW Routines for Planning Post-Scan/Join Processing If an FDW supports performing remote post-scan/join processing, such as remote aggregation, it should provide this callback functi…FDW Routines for Planning Post-Scan/Join Processing FDW Routines for Reparameterization of PathsManual ChaptersPG1858.2.12. FDW Routines for Reparameterization of Paths List * ReparameterizeForeignPathByChild(PlannerInfo *root, List *fdw_private, RelOptInfo *child_rel); This function is called while conv…FDW Routines for Reparameterization of Paths FDW Routines for Row LockingManual ChaptersPG1858.2.6. FDW Routines for Row Locking If an FDW wishes to support late row locking (as described in Section 58.5), it must provide the following callback functions: RowMarkType GetForeignRowM…FDW Routines for Row Locking FDW Routines for Scanning Foreign JoinsManual ChaptersPG1858.2.2. FDW Routines for Scanning Foreign Joins If an FDW supports performing foreign joins remotely (rather than by fetching both tables' data and doing the join locally), it should provide…FDW Routines for Scanning Foreign Joins FDW Routines for Scanning Foreign TablesManual ChaptersPG1858.2.1. FDW Routines for Scanning Foreign Tables void GetForeignRelSize(PlannerInfo *root, RelOptInfo *baserel, Oid foreigntableid); Obtain relation size estimates for a foreign table. This …FDW Routines for Scanning Foreign Tables FDW Routines for TRUNCATEManual ChaptersPG1858.2.5. FDW Routines for TRUNCATE void ExecForeignTruncate(List *rels, DropBehavior behavior, bool restart_seqs); Truncate foreign tables. This function is called when TRUNCATE is executed o…FDW Routines for TRUNCATE FDW Routines for Updating Foreign TablesManual ChaptersPG1858.2.4. FDW Routines for Updating Foreign Tables If an FDW supports writable foreign tables, it should provide some or all of the following callback functions depending on the needs and capa…FDW Routines for Updating Foreign Tables fdw_handlerData TypesPG18fdw_handler A foreign-data wrapper handler is declared to return fdw_handler.Pseudo-Types FeaturesManual ChaptersPG18F.40.5. FeaturesFeatures festivalExtensionsExtensionsFESTIval is a PostgreSQL extension for conducting performance evaluations of spatial indices dataset-generation flash-memory postgis-extension postgresql-extension r-trees spatial-index fest…Geospatial · Extensions FETCHManual ChaptersPG1841.7.3.1. FETCH FETCH [ direction { FROM | IN } ] cursor INTO target; FETCH retrieves the next row (in the indicated direction) from the cursor into a target, which might be a row variable, …FETCH FETCHManual ChaptersPG18FETCH FETCH — retrieve rows from a query using a cursor Synopsis FETCH [ direction ] [ FROM | IN ] cursor_name where direction can be one of: NEXT PRIOR FIRST LAST ABSOLUTE count RELATIVE co…FETCH