Search PostgreSQL documentation

pg_init_privsManual ChaptersPG18The catalog pg_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the database which has a non-default (non-NULL) ini… pg_injectionExtensionsExtensionsSecurity · ExtensionsPostgreSQL injection injection pg_injection Security pg_intmapExtensionsExtensionsData types · ExtensionsCompressed integer-to-integer map adjust-kpis-team pg_intmap Data types pg_isokExtensionsExtensionsUtilities · ExtensionsQuery-based data integrity management and soft alerting for PostgreSQL pg_isok Utilities pg_isolateExtensionsExtensionsAdministration · ExtensionsAssign PostgreSQL backends to Linux cgroups for resource isolation cgroup preload resource-control pg_isolate Administration pg_isreadyCommand-line ToolsPG18check the connection status of a PostgreSQL server Synopsis pg_isready [connection-option...] [option...] pg_isreadyManual ChaptersPG18check the connection status of a PostgreSQL server Synopsis pg_isready [connection-option...] [option...] pg_isready --dbname=dbnameCommand-line ToolsPG18pg_isready › Optionsd dbname--dbname=dbname Specifies the name of the database to connect to. The dbname can be a connection string. If so, connection string parameters will override any conflicting command lin… pg_isready --helpCommand-line ToolsPG18pg_isready › Options?--help Show help about pg_isready command line arguments, and exit. pg_isready --host=hostnameCommand-line ToolsPG18pg_isready › Optionsh hostname--host=hostname Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix-domain socket. pg_isready --port=portCommand-line ToolsPG18pg_isready › Optionsp port--port=port Specifies the TCP port or the local Unix-domain socket file extension on which the server is listening for connections. Defaults to the value of the PGPORT environment vari… pg_isready --quietCommand-line ToolsPG18pg_isready › Optionsq--quiet Do not display status message. This is useful when scripting. pg_isready --timeout=secondsCommand-line ToolsPG18pg_isready › Optionst seconds--timeout=seconds The maximum number of seconds to wait when attempting connection before returning that the server is not responding. Setting to 0 disables. The default is 3 second… pg_isready --username=usernameCommand-line ToolsPG18pg_isready › OptionsU username--username=username Connect to the database as the user username instead of the default. pg_isready --versionCommand-line ToolsPG18pg_isready › OptionsV--version Print the pg_isready version and exit. pg_ivfflatExtensionsExtensionsAI and vectors · ExtensionsExperimental pgrx extension providing a Vector type and an in-memory IVFFlat index access method. index ivf pgrx vector pg_ivfflat AI and vectors pg_ivmExtensionsExtensionsFeatures · Extensionsincremental view maintenance on PostgreSQL pg_ivm Features pg_jalali_calendarExtensionsExtensionsTime series · ExtensionsJalali/Persian calendar date conversion and helper functions for PostgreSQL. calendar jalali pgrx pg_jalali_calendar Time series pg_jewelry_toolsExtensionsExtensionsFunctions and aggregates · ExtensionsAn extension for PSQL with useful functionality for jewelry companies. So far, this is a project created for educational purposes. pg_jewelry_tools Functions and aggregates pg_jiebaExtensionsExtensionsFull-text search · ExtensionsChinese full-text search parser based on cppjieba pg_jieba Full-text search pg_jinxExtensionsExtensionsProcedural languages · ExtensionsJNI bridge for PostgreSQL stored procedures, triggers, and foreign data wrappers written in Java. java jni fdw stored-procedure pg_jinx Procedural languages pg_jobmonExtensionsExtensionsSecurity · ExtensionsExtension for logging and monitoring functions in PostgreSQL pg_jobmon Security pg_jqExtensionsExtensionsUtilities · ExtensionsToy extension exposing libjq filters for PostgreSQL json and jsonb values. pgrx rust pg_jq Utilities pg_json_diffExtensionsExtensionsFunctions and aggregates · ExtensionsJSONB diff, JSON Patch, and merge-patch functions for PostgreSQL diff jsonb merge patch pg_json_diff Functions and aggregates pg_json_validateExtensionsExtensionsFeatures · ExtensionsJSON Schema validation functions for jsonb values. pg_json_validate Features pg_jsonpatchExtensionsExtensionsFunctions and aggregates · ExtensionsPostgreSQL implementation of JSON Patch jsonpatch nix postgresql postgresql-extension pg_jsonpatch Functions and aggregates pg_jsonschemaExtensionsExtensionsFeatures · ExtensionsPostgreSQL extension providing JSON Schema validation pgrx supabase pg_jsonschema Features pg_kaboomExtensionsExtensionsFeatures · ExtensionsBlow things up in interesting and useful^W^W ways crash failover kaboom testing pg_kaboom Features pg_kafkaExtensionsExtensionsForeign data wrappers · ExtensionsKafka foreign data wrapper for PostgreSQL. kafka pgrx postgresql rust pg_kafka Foreign data wrappers pg_kafka_eventsExtensionsExtensionsReplication and streams · ExtensionsPublishes PostgreSQL logical-decoding change events to Apache Kafka through a background worker. kafka pg_kafka_events Replication and streams pg_kalamExtensionsExtensionsForeign data wrappers · ExtensionsKalamDB PostgreSQL extension and FDW callback layer for SQL access to KalamDB. fdw pgrx kalam-pg-extension Foreign data wrappers pg_kalmanExtensionsExtensionsFunctions and aggregates · ExtensionsA Kalman filter extension for PostgreSQL. pg_kalman Functions and aggregates pg_kazsearchExtensionsExtensionsFull-text search · ExtensionsKazakh full-text search extension for PostgreSQL pgrx pg_kazsearch Full-text search pg_keeperExtensionsExtensionsAdministration · ExtensionsBackground-worker based clustering module for monitoring streaming replication, changing synchronous replication mode and promoting a standby on failure. pg_keeper Administration pg_kiwiExtensionsExtensionsFull-text search · ExtensionsKorean full-text search using the Kiwi morphological analyzer korean full-text-search pg_kiwi Full-text search pg_kmersearchExtensionsExtensionsAI and vectors · ExtensionsA PostgreSQL extension adding 2 datatypes of 2-bit or 4-bit per 1-mer for nucleotide sequence data and GIN index based on k-mer pg_kmersearch AI and vectors pg_knowledge_graphExtensionsExtensionsAI and vectors · ExtensionsKnowledge graph extension for PostgreSQL with graph algorithms and pgvector integration. graph pgrx rag vector pg_knowledge_graph AI and vectors pg_kpartExtensionsExtensionsSecurity · ExtensionsReject full partition scans that omit the partition key pg_kpart Security pg_ladybugExtensionsExtensionsFeatures · ExtensionsCypher queries over PostgreSQL tables through an embedded Ladybug graph engine. graph cypher ladybugdb extension-scan pg_ladybug Features pg_lakeExtensionsExtensionsAnalytics · ExtensionsData lake extension by Snowflake data-lake duckdb fdw iceberg pg_lake Analytics