Search PostgreSQL documentation

pg_file_settingsManual ChaptersPG18The view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each “name = value” entry appearing in the files, with anno… pg_fiuExtensionsExtensionsFeatures · ExtensionsFault-injection extension for PostgreSQL using libfiu fault-injection testing pg_fiu Features pg_fk_indexerExtensionsExtensionsAdministration · ExtensionsAutomatically creates indexes for newly defined foreign-key columns. foreign-key index automation hook pg_fk_indexer Administration pg_fkpartExtensionsExtensionsAnalytics · ExtensionsTable partitioning by foreign key utility pgdg-flaw pg_fkpart Analytics pg_flashbackExtensionsExtensionsTime series · ExtensionsTable-level point-in-time restore and time-travel queries for PostgreSQL using trigger or WAL capture. pgrx pg_flashback Time series pg_flatbuffersExtensionsExtensionsUtilities · Extensionsquery and convert FlatBuffers payloads in bytea columns flatbuffers pgrx postgresql pg_flatbuffers Utilities pg_followerExtensionsExtensionsReplication and streams · ExtensionsEducational logical-replication extension that captures and applies database changes background-worker logical-replication pg_follower Replication and streams pg_foobarExtensionsExtensionsFeatures · ExtensionsDemonstrates PostgreSQL parallel workers by launching workers that write configurable foo and bar messages to the server log. pg_foobar Features pg_force_unlogged_create_tableExtensionsExtensionsAdministration · Extensionsforce CREATE TABLE to create UNLOGGED tables pg_force_unlogged_create_table Administration pg_foreign_data_wrapperManual ChaptersPG18The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data, residing on foreign servers, is accessed. Table 5… pg_foreign_serverManual ChaptersPG18The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server. Foreign servers are accessed via foreign-data … pg_foreign_tableManual ChaptersPG18The catalog pg_foreign_table contains auxiliary information about foreign tables. A foreign table is primarily represented by a pg_class entry, just like a regular table. Its pg_foreign_tabl… pg_fossaExtensionsExtensionsFeatures · ExtensionsArchived SQL extension supporting FOSSA hasGraph data structures and queries. fossa graph hasgraph provider pg_fossa Features pg_fractionExtensionsExtensionsData types · ExtensionsAdds a fraction data type with arithmetic, comparison, aggregate and B-tree operator-class support. pg_fraction Data types pg_freespacemapExtensionsPG18pg_freespacemap — examine the free space mapexamine the free space map The pg_freespacemap module provides a means for examining the free space map (FSM). It provides a function called pg_freespace, or two overloaded functions, to be … pg_freespacemap — examine the free space mapManual ChaptersPG18The pg_freespacemap module provides a means for examining the free space map (FSM). It provides a function called pg_freespace, or two overloaded functions, to be precise. The functions show… pg_french_datatypesExtensionsExtensionsData types · Extensionsfrench-centric data type data types france pg_french_datatypes Data types pg_frozenExtensionsExtensionsAdministration · ExtensionsExposes a frozen(tid) function that explains if a tuple has been frozen pg_frozen Administration pg_fsqlExtensionsExtensionsUtilities · ExtensionsRecursive SQL template engine with JSONB-driven execution pg_fsql Utilities pg_ftsExtensionsExtensionsFull-text search · ExtensionsFull-text search with BM25 and BM25F ranking fts bm25 bm25f pg_fts Full-text search pg_fts_greekExtensionsExtensionsFull-text search · ExtensionsPostgres FTS Improvements for Greek full-text-search nlp postgresql postgresql-extension pg_fts_greek Full-text search pg_fuck_blockExtensionsExtensionsAdministration · ExtensionsC extension for reading all tuples from a relation block page-inspection storage pg_get_page_tuple Administration pg_fusionExtensionsExtensionsAnalytics · ExtensionsExperimental PostgreSQL extension for DataFusion-backed analytical query execution datafusion olap pgrx pg_fusion Analytics pg_fxExtensionsExtensionsFeatures · ExtensionsExact FX rates, pricing rules, and expiring quotes fx pricing quotes pg_fx Features pg_gembedExtensionsExtensionsAI and vectors · ExtensionsGenerate embeddings inside PostgreSQL ai embeddings machine-learning vector pg_gembed AI and vectors pg_gen_queryExtensionsExtensionsAI and vectors · ExtensionsA PostgreSQL extension written in C++ that adds no-maintenance GenAI querying functionality using Clickhouse's AI SDK ai genai-usecase postgresql postgresql-extension pg_gen_query AI and vec… pg_gen_uidExtensionsExtensionsFunctions and aggregates · ExtensionsAdds a PL/pgSQL function that generates random lowercase alphanumeric identifiers using pgcrypto. pg_gen_uid Functions and aggregates pg_genotypeExtensionsExtensionsData types · ExtensionsProvides a compact one-byte genotype type that preserves allele order and supports insertion and deletion symbols. pg_genotype Data types pg_geohashExtensionsExtensionsGeospatial · ExtensionsHandle geohash based functionality for spatial coordinates nil-lic pg_geohash Geospatial pg_geohash_extraExtensionsExtensionsGeospatial · ExtensionsAdditional geohash functions for PostGIS geohash geojson geospatial grid statistics pg_geohash_extra Geospatial pg_get_functiondefExtensionsExtensionsCompatibility · ExtensionsGet function's definition fork ivory ivorysql Compatibility pg_get_queryidExtensionsExtensionsMonitoring · Extensionsget last queryid generated/used by pg_stat_statements for a given backend pid monitoring query-id pg_get_queryid Monitoring pg_gist_hammingExtensionsExtensionsAI and vectors · Extensionssupport for indexing common datatypes in GiST pg_gist_hamming AI and vectors pg_gitExtensionsExtensionsFeatures · ExtensionsImplements Git-like repositories, commits, branches, merges and remote operations using PostgreSQL-native data and functions. git pg_git Features pg_global_catalogExtensionsExtensionsAdministration · ExtensionsPostgreSQL global catalog catalog dictionary global postgresql-extension postgresql-plpgsql shared pg_global_catalog Administration pg_gnuplotExtensionsExtensionsUtilities · ExtensionsPostgreSQL extension to plot graphs using GNUPlot pg_gnuplot Utilities pg_gptExtensionsExtensionsAI and vectors · ExtensionsExperimental extension that brings OpenAI API to your PostgreSQL to run queries in human language. chatgpt cloudquery pgrx postgresql rust sql pg_gpt AI and vectors pg_grab_statementExtensionsExtensionsMonitoring · ExtensionsRecord detailed SQL statements from successfully committed transactions. monitoring query-statistics workload pg_grab_statement Monitoring pg_grammar_guardExtensionsExtensionsAI and vectors · ExtensionsCatalog-derived grammars and approved grammar drift checks grammar llm catalog pg_grammar_guard AI and vectors pg_graphqlExtensionsExtensionsFeatures · ExtensionsAdd in-database GraphQL support pgrx supabase pg_graphql Features