Search PostgreSQL documentation

floatvecExtensionsExtensionsMath for vectors (arrays) of numbers floatvec Functions and aggregatesFunctions and aggregates · Extensions floorFunctionsReferencefloor Mathematical Functions And Operators 10 nearest integer less than or equal to argument floor ( dp or numeric ) → (same as input) nearest integer less than or equal to argument 11 12 13…Functions · Mathematical Functions And Operators flow_controlExtensionsExtensionsAmazon RDS for PostgreSQL extension that throttles writes in Multi-AZ DB clusters to reduce replica lag. aws flow-control multi-az rds replica-lag flow_control AdministrationAdministration · Extensions fluxExtensionsExtensionsLogs table data changes and reconstructs rows as they existed in the past. audit history hstore trigger flux Time seriesTime series · Extensions fmodel_rust_postgresExtensionsExtensionsRun f{model} event-sourced domain models inside PostgreSQL as a pgrx extension. cqrs ddd event-sourcing pgrx fmodel_rust_postgres FeaturesFeatures · Extensions fnvhashExtensionsExtensionsFNV hash functions for PostgreSQL. fnv function hash fnvhash Functions and aggregatesFunctions and aggregates · Extensions FOR (Integer Variant)Manual ChaptersPG1841.6.5.5. FOR (Integer Variant) [ <<label>> ] FOR name IN [ REVERSE ] expression .. expression [ BY expression ] LOOP statements END LOOP [ label ]; This form of FOR creates a loop that iter…FOR (Integer Variant) FOR KEY SHARESQL CommandsPG18FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHARE Although FOR UPDATE appears in the SQL standard, the standard allows it only as an option of DECLARE CURSOR. PostgreSQL allows it in a…SELECT › Compatibility › FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHARE FOR NO KEY UPDATESQL CommandsPG18FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHARE Although FOR UPDATE appears in the SQL standard, the standard allows it only as an option of DECLARE CURSOR. PostgreSQL allows it in a…SELECT › Compatibility › FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHARE FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHAREManual ChaptersPG18FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHARE Although FOR UPDATE appears in the SQL standard, the standard allows it only as an option of DECLARE CURSOR. PostgreSQL allows it in a…FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHARE FOR SHARESQL CommandsPG18FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHARE Although FOR UPDATE appears in the SQL standard, the standard allows it only as an option of DECLARE CURSOR. PostgreSQL allows it in a…SELECT › Compatibility › FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHARE For the ProgrammerManual ChaptersPG1856.2. For the ProgrammerFor the Programmer For the TranslatorManual ChaptersPG1856.1. For the Translator PostgreSQL programs (server and client) can issue their messages in your favorite language — if the messages have been translated. Creating and maintaining translate…For the Translator FOR UPDATESQL CommandsPG18FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHARE Although FOR UPDATE appears in the SQL standard, the standard allows it only as an option of DECLARE CURSOR. PostgreSQL allows it in a…SELECT › Compatibility › FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE, FOR KEY SHARE forbid_truncateExtensionsExtensionsPreload hook extension that rejects TRUNCATE commands. postgres_extension AdministrationAdministration · Extensions force_parallel_modeConfigurationReferenceforce_parallel_mode Developer Options 10 Allows the use of parallel queries for testing purposes even in cases where no performance benefit is expected. The allowed values of force_parallel_…Configuration · Developer Options Foreign DataManual ChaptersPG185.13. Foreign Data PostgreSQL implements portions of the SQL/MED specification, allowing you to access data that resides outside PostgreSQL using regular SQL queries. Such data is referred t…Foreign Data Foreign Data Wrapper Callback RoutinesManual ChaptersPG1858.2. Foreign Data Wrapper Callback Routines The FDW handler function returns a palloc'd FdwRoutine struct containing pointers to the callback functions described below. The scan-related fun…Foreign Data Wrapper Callback Routines Foreign Data Wrapper FunctionsManual ChaptersPG1858.1. Foreign Data Wrapper Functions The FDW author needs to implement a handler function, and optionally a validator function. Both functions must be written in a compiled language such as …Foreign Data Wrapper Functions Foreign Data Wrapper Helper FunctionsManual ChaptersPG1858.3. Foreign Data Wrapper Helper Functions Several helper functions are exported from the core server so that authors of foreign data wrappers can get easy access to attributes of FDW-relat…Foreign Data Wrapper Helper Functions Foreign Data Wrapper Query PlanningManual ChaptersPG1858.4. Foreign Data Wrapper Query Planning The FDW callback functions GetForeignRelSize, GetForeignPaths, GetForeignPlan, PlanForeignModify, GetForeignJoinPaths, GetForeignUpperPaths, and Pla…Foreign Data Wrapper Query Planning Foreign Key ConstraintsManual ChaptersPG18Foreign Key Constraints The ability to specify column lists in the foreign key actions SET DEFAULT and SET NULL is a PostgreSQL extension. It is a PostgreSQL extension that a foreign key con…Foreign Key Constraints Foreign KeysManual ChaptersPG185.5.5. Foreign Keys A foreign key constraint specifies that the values in a column (or a group of columns) must match the values appearing in some row of another table. We say this maintains…Foreign Keys Foreign KeysManual ChaptersPG183.3. Foreign Keys Recall the weather and cities tables from Chapter 2. Consider the following problem: You want to make sure that no one can insert rows in the weather table that do not have…Foreign Keys foreign_data_wrapper_optionsManual ChaptersPG1835.26. foreign_data_wrapper_options The view foreign_data_wrapper_options contains all the options defined for foreign-data wrappers in the current database. Only those foreign-data wrappers…foreign_data_wrapper_options foreign_data_wrappersManual ChaptersPG1835.27. foreign_data_wrappers The view foreign_data_wrappers contains all foreign-data wrappers defined in the current database. Only those foreign-data wrappers are shown that the current us…foreign_data_wrappers foreign_server_optionsManual ChaptersPG1835.28. foreign_server_options The view foreign_server_options contains all the options defined for foreign servers in the current database. Only those foreign servers are shown that the curr…foreign_server_options foreign_serversManual ChaptersPG1835.29. foreign_servers The view foreign_servers contains all foreign servers defined in the current database. Only those foreign servers are shown that the current user has access to (by way…foreign_servers foreign_table_exposerExtensionsExtensionsExposes foreign tables as regular tables for catalog-based clients. fdw foreign-data-wrapper query-rewrite foreign_table_exposer UtilitiesUtilities · Extensions foreign_table_optionsManual ChaptersPG1835.30. foreign_table_options The view foreign_table_options contains all the options defined for foreign tables in the current database. Only those foreign tables are shown that the current …foreign_table_options foreign_tablesManual ChaptersPG1835.31. foreign_tables The view foreign_tables contains all foreign tables defined in the current database. Only those foreign tables are shown that the current user has access to (by way of …foreign_tables formatManual ChaptersPG189.4.1. format The function format produces output formatted according to a format string, in a style similar to the C function sprintf. format(formatstr text [, formatarg "any" [, ...] ]) fo…format formatFunctionsReferenceformat String Functions And Operators 10 Format arguments according to a format string. This function is similar to the C function sprintf. See Section 9.4.1. format ( formatstr text [, form…Functions · String Functions And Operators formatExtensionsExtensionsA string formatting function which takes named parameters format Functions and aggregatesFunctions and aggregates · Extensions format_typeFunctionsReferenceformat_type System Information Functions And Operators 10 get SQL name of a data type format_type ( type_oid, typemod ) → text get SQL name of a data type 11 12 13 Returns the SQL name for a…Functions · System Information Functions And Operators format_xExtensionsExtensionsPolymorphic variadic string formatting with named lookups into composite, JSONB, and HSTORE values. formatting named-parameters polymorphic string-interpolation variadic format_x Functions a…Functions and aggregates · Extensions formatbaseExtensionsExtensionsC functions to format numbers and parse strings by numeric base. formatbase UtilitiesUtilities · Extensions Formats and Format CodesManual ChaptersPG1854.1.3. Formats and Format Codes Data of a particular data type might be transmitted in any of several different formats. As of PostgreSQL 7.4 the only supported formats are “text” and “bina…Formats and Format Codes FormattingManual ChaptersPG1855.1. Formatting Source code formatting uses 4 column tab spacing, with tabs preserved (i.e., tabs are not expanded to spaces). Each logical indentation level is one additional tab stop. Lay…Formatting frapiExtensionsExtensionsIn-database wrappers for French public-administration data APIs. api geocoding postgis pg_frapi GeospatialGeospatial · Extensions