Search PostgreSQL documentation

dblink_closeManual ChaptersPG18dblink_close dblink_close — closes a cursor in a remote database Synopsis dblink_close(text cursorname [, bool fail_on_error]) returns text dblink_close(text connname, text cursorname [, boo…dblink_close dblink_connectManual ChaptersPG18dblink_connect dblink_connect — opens a persistent connection to a remote database Synopsis dblink_connect(text connstr) returns text dblink_connect(text connname, text connstr) returns textdblink_connect dblink_connect_uManual ChaptersPG18dblink_connect_u dblink_connect_u — opens a persistent connection to a remote database, insecurely Synopsis dblink_connect_u(text connstr) returns text dblink_connect_u(text connname, text c…dblink_connect_u dblink_disconnectManual ChaptersPG18dblink_disconnect dblink_disconnect — closes a persistent connection to a remote database Synopsis dblink_disconnect() returns text dblink_disconnect(text connname) returns textdblink_disconnect dblink_error_messageManual ChaptersPG18dblink_error_message dblink_error_message — gets last error message on the named connection Synopsis dblink_error_message(text connname) returns textdblink_error_message dblink_execManual ChaptersPG18dblink_exec dblink_exec — executes a command in a remote database Synopsis dblink_exec(text connname, text sql [, bool fail_on_error]) returns text dblink_exec(text connstr, text sql [, bool…dblink_exec dblink_fetchManual ChaptersPG18dblink_fetch dblink_fetch — returns rows from an open cursor in a remote database Synopsis dblink_fetch(text cursorname, int howmany [, bool fail_on_error]) returns setof record dblink_fetch…dblink_fetch dblink_get_connectionsManual ChaptersPG18dblink_get_connections dblink_get_connections — returns the names of all open named dblink connections Synopsis dblink_get_connections() returns text[]dblink_get_connections dblink_get_notifyManual ChaptersPG18dblink_get_notify dblink_get_notify — retrieve async notifications on a connection Synopsis dblink_get_notify() returns setof (notify_name text, be_pid int, extra text) dblink_get_notify(tex…dblink_get_notify dblink_get_pkeyManual ChaptersPG18dblink_get_pkey dblink_get_pkey — returns the positions and field names of a relation's primary key fields Synopsis dblink_get_pkey(text relname) returns setof dblink_pkey_resultsdblink_get_pkey dblink_get_resultManual ChaptersPG18dblink_get_result dblink_get_result — gets an async query result Synopsis dblink_get_result(text connname [, bool fail_on_error]) returns setof recorddblink_get_result dblink_is_busyManual ChaptersPG18dblink_is_busy dblink_is_busy — checks if connection is busy with an async query Synopsis dblink_is_busy(text connname) returns intdblink_is_busy dblink_openManual ChaptersPG18dblink_open dblink_open — opens a cursor in a remote database Synopsis dblink_open(text cursorname, text sql [, bool fail_on_error]) returns text dblink_open(text connname, text cursorname, …dblink_open dblink_plusExtensionsExtensionsRun SQL against external PostgreSQL, Oracle, MySQL, and SQLite databases from PostgreSQL. dblink mysql oracle sqlite dblink_plus Foreign data wrappersForeign data wrappers · Extensions dblink_send_queryManual ChaptersPG18dblink_send_query dblink_send_query — sends an async query to a remote database Synopsis dblink_send_query(text connname, text sql) returns intdblink_send_query dbms_jobExtensionsExtensionsEPAS Oracle-compatible DBMS_JOB package backed by EDB Job Scheduler. oracle scheduler jobs compatibility edb_job_scheduler Time seriesTime series · Extensions dbms_schedulerExtensionsExtensionsEPAS Oracle-compatible DBMS_SCHEDULER programs, schedules, and jobs. oracle scheduler jobs compatibility edb_job_scheduler Time seriesTime series · Extensions dbms_sqlExtensionsExtensionsImplements a subset of Oracle's DBMS_SQL package API to ease application migration to PostgreSQL. dbms-sql migration oracle-compatibility dbms_sql CompatibilityCompatibility · Extensions dbnameCommand-line ToolsPG18dbname The database name. Defaults to be the same as the user name. In certain contexts, the value is checked for extended formats; see Section 32.1.1 for more details on those.Database Connection Control Functions › Parameter Key Words dbpatchExtensionsExtensionsPostgreSQL database patch change management extension change database deploying management patch dbpatch AdministrationAdministration · Extensions dbstatExtensionsExtensionsCollects exact table row counts and modification timing through SQL objects and a companion libpq process. monitoring statistics dbstat MonitoringMonitoring · Extensions dbstatsExtensionsExtensionsDescriptive statistics and data quality analysis for PostgreSQL dbstats Functions and aggregatesFunctions and aggregates · Extensions dbt2ExtensionsExtensionsOSDL-DBT-2 test kit test dbt2 Procedural languagesProcedural languages · Extensions dbtune_mabExtensionsExtensionsDBTune MAB advisor for PostgreSQL dbtune_mab FeaturesFeatures · Extensions dc_fdwExtensionsExtensionsHistorical foreign data wrapper for document collections stored on local disk. fdw document filesystem collection dc_fdw Foreign data wrappersForeign data wrappers · Extensions DDL PermissionsManual ChaptersPG18F.40.5.3. DDL Permissions SELinux defines several permissions to control common operations for each object type; such as creation, alter, drop and relabel of security label. In addition, sev…DDL Permissions ddl_command_endManual ChaptersPG1838.1.3. ddl_command_end The ddl_command_end event occurs just after the execution of the same set of commands as ddl_command_start. To obtain more details on the DDL operations that took pla…ddl_command_end ddl_command_startManual ChaptersPG1838.1.2. ddl_command_start The ddl_command_start event occurs just before the execution of a DDL command. DDL commands in this context are: CREATE ALTER DROP COMMENT GRANT IMPORT FOREIGN SCHE…ddl_command_start ddl_historizationExtensionsExtensionsHistorize the ddl changes inside PostgreSQL database ddl_historization UtilitiesUtilities · Extensions ddl_replExtensionsExtensionsReplicate DDL and DCL commands across PostgreSQL instances by means of a utility hook ddl hook replication pg_repl Replication and streamsReplication and streams · Extensions ddl_versioningExtensionsExtensionsDDL object versioning with event triggers for tables, indexes, functions, and views. ddl event-trigger versioning ddl_versioning AdministrationAdministration · Extensions ddlaExtensionsExtensionsAudit DDL changes with event triggers and queryable log functions audit ddl event-trigger ddla SecuritySecurity · Extensions ddlxExtensionsExtensionsDDL eXtractor functions pgdg-flaw pg_ddlx AdministrationAdministration · Extensions ddsketchExtensionsExtensionsProvides ddsketch aggregate function beta ddsketch Functions and aggregatesFunctions and aggregates · Extensions deadlock_timeoutConfigurationReferencedeadlock_timeout Lock Management 10 This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition. The check for deadlock is relative…Configuration · Lock Management DeadlocksManual ChaptersPG1813.3.4. Deadlocks The use of explicit locking can increase the likelihood of deadlocks, wherein two (or more) transactions each hold locks that the other wants. For example, if transaction 1…Deadlocks DEALLOCATEManual ChaptersPG18DEALLOCATE DEALLOCATE — deallocate a prepared statement Synopsis DEALLOCATE [ PREPARE ] { name | ALL }DEALLOCATE DEALLOCATESQL CommandsReferenceDEALLOCATE Cursors & Prepared Statements 10 deallocate a prepared statement DEALLOCATE [ PREPARE ] { name | ALL } DEALLOCATE is used to deallocate a previously prepared SQL statement. If you…SQL Commands · Cursors & Prepared Statements DEALLOCATE DESCRIPTORManual ChaptersPG18DEALLOCATE DESCRIPTOR DEALLOCATE DESCRIPTOR — deallocate an SQL descriptor area Synopsis DEALLOCATE DESCRIPTOR nameDEALLOCATE DESCRIPTOR Debian PackagesManual ChaptersPG18J.2.3. Debian Packages There is a full set of packages of the documentation tools available for Debian GNU/Linux. To install, simply use: apt-get install docbook-xml docbook-xsl libxml2-util…Debian Packages