Search PostgreSQL documentation

pg_durationExtensionsExtensionsData types · Extensionsdata type for representing durations pg_duration Data types pg_dynamicExtensionsExtensionsData types · ExtensionsExperimental dynamic values with casts and overloaded operators. pg_dynamic Data types pg_ecdsa_verifyExtensionsExtensionsSecurity · ExtensionsECDSA signature verification functions for PostgreSQL cryptography ecdsa pgrx signature-verification pg_ecdsa_verify Security pg_ed25519ExtensionsExtensionsSecurity · ExtensionsEd25519 signing and signature-verification functions for PostgreSQL cryptography ed25519 signature pg_ed25519 Security pg_eddyExtensionsExtensionsFeatures · ExtensionsA Postgres extension for labeled property graphs with index-free adjacency and built-in materialized views. pg_eddy Features pg_elephantExtensionsExtensionsFunctions and aggregates · ExtensionsToy example extension exposing a pg_elephant() function that returns ASCII elephant text. ascii-art example toy pg_elephant Functions and aggregates pg_elephantduckExtensionsExtensionsAnalytics · ExtensionsColumnar PostgreSQL table access method powered by DuckDB and Parquet storage. columnar duckdb parquet pgrx table-access-method pg_elephantduck Analytics pg_embedExtensionsExtensionsAI and vectors · ExtensionsGenerate and store OpenAI embeddings in-place pg_embed AI and vectors pg_embedderExtensionsExtensionsAI and vectors · ExtensionsIn-backend text embedding inference using Rust, Candle, and packaged models. embedding candle inference vector pg_embedder AI and vectors pg_emdExtensionsExtensionsAI and vectors · ExtensionsFast approximate Earth Mover's Distance using dynamic tree embeddings earth-movers-distance emd pgrx similarity tree-embedding pg_emd AI and vectors pg_enigmaExtensionsExtensionsSecurity · ExtensionsEncrypted postgres data type pgrx pg_enigma Security pg_enquoExtensionsExtensionsSecurity · ExtensionsPostgreSQL extension for encrypted query operations encrypted-query encryption pgrx searchable-encryption pg_enquo Security pg_enumManual ChaptersPG18The pg_enum catalog contains entries showing the values and labels for each enum type. The internal representation of a given enum value is actually the OID of its associated row in pg_enum.… pg_erlang_termExtensionsExtensionsData types · ExtensionsPostgreSQL type for encoding, storing, and decoding Erlang External Term Format values. erlang external-term codec type pg_erlang_term Data types pg_etagExtensionsExtensionsFunctions and aggregates · ExtensionsFast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates. aggregate blake2 etag hash pg_etag Functions and aggregates pg_ethiopian_calendarExtensionsExtensionsTime series · ExtensionsConvert between Gregorian and Ethiopian calendar dates calendar pg_ethiopian_calendar Time series pg_ethopicExtensionsExtensionsFunctions and aggregates · ExtensionsFormat Ethiopic dates and numbers in PostgreSQL. calendar pgrx pg_ethopic Functions and aggregates pg_event_triggerManual ChaptersPG18The catalog pg_event_trigger stores event triggers. See Chapter 38 for more information. Table 52.21. pg_event_trigger Columns Column Type Description oid oid Row identifier evtname name Tri… pg_eviltransformExtensionsExtensionsGeospatial · ExtensionsCoordinate transforms for BD09/GCJ02 via PostGIS ST_Transform pgrx pg_eviltransform Geospatial pg_exclusive_backupExtensionsExtensionsAdministration · ExtensionsCompatibility functions for exclusive-style physical backup on PostgreSQL 15 or later. backup exclusive compatibility pg15 pg_exclusive_backup Administration pg_extensionManual ChaptersPG18The catalog pg_extension stores information about the installed extensions. See Section 36.17 for details about extensions. Table 52.22. pg_extension Columns Column Type Description oid oid … pg_extensionExtensionsExtensionsAI and vectors · ExtensionsIn-database model slicing and inference helper functions for structured data analytics. pgrx indices AI and vectors pg_extension_baseExtensionsExtensionsAnalytics · ExtensionsExtension development kit by Snowflake background-worker preload pg_lake Analytics pg_extension_updaterExtensionsExtensionsAnalytics · ExtensionsAutomatic extension updater background-worker preload update pg_lake Analytics pg_extismExtensionsExtensionsProcedural languages · ExtensionsAn Extism sample showing how you can run Extism plugins from PostgreSQl using pgrx! extism pgrx postgresql rust wasm pg_extism Procedural languages pg_extra_timeExtensionsExtensionsUtilities · ExtensionsSome date time functions and operators that, pg_extra_time Utilities pg_eyesExtensionsExtensionsMonitoring · ExtensionsSQL monitoring functions and views for PostgreSQL database activity monitoring statistics pg_eyes Monitoring pg_fact_loaderExtensionsExtensionsReplication and streams · Extensionsbuild fact tables with Postgres pg_fact_loader Replication and streams pg_failover_slotsExtensionsExtensionsReplication and streams · ExtensionsPG Failover Slots extension pg_failover_slots Replication and streams pg_fairmlqExtensionsExtensionsFeatures · ExtensionsPL/pgSQL only implementation of a fair multi-level queue for multi-tenant applications pg_fairmlq Features pg_fallback_utf8_to_euc_jpExtensionsExtensionsUtilities · ExtensionsProvides a fallback UTF-8 to EUC_JP encoding conversion that substitutes unmappable characters with a question mark. pg_fallback_utf8_to_euc_jp Utilities pg_fasttransferExtensionsExtensionsReplication and streams · ExtensionsPostgresql Extension for FastTransfer pg_fasttransfer Replication and streams pg_featureExtensionsExtensionsAI and vectors · ExtensionsSQL feature synthesis across table relationships and time cutoffs. pgrx proof-of-concept pg_extensions AI and vectors pg_fediExtensionsExtensionsFeatures · ExtensionsPure-SQL ActivityPub federation primitives for PostgreSQL and pg_tle environments. activitypub federation tle social pg_fedi Features pg_feedbackExtensionsExtensionsMonitoring · ExtensionsPostgreSQL extension that generates a report about database usage feedback usage pg_feedback Monitoring pg_felaExtensionsExtensionsAI and vectors · ExtensionsThe holy grail of AutoML for PG - self classifying and regressing tabular data! automl machine-learning postgresql-extension rust pg_fela AI and vectors pg_ferroidExtensionsExtensionsData types · ExtensionsPostgreSQL ULID type and generation functions backed by ferroid pgrx pg_ferroid Data types pg_ffmpegExtensionsExtensionsUtilities · ExtensionsExposes FFmpeg media processing functions inside PostgreSQL through a pgrx extension. pgrx pg_ffmpeg Utilities pg_fheExtensionsExtensionsSecurity · ExtensionsMicrosoft SEAL-backed CKKS operations over encrypted values stored in PostgreSQL. fhe homomorphic-encryption ckks seal pg_fhe Security 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…