Search PostgreSQL documentation

pg_trigger_depthFunctionsReferencepg_trigger_depth System Information Functions And Operators 10 current nesting level of PostgreSQL triggers (0 if not called, directly or indirectly, from inside a trigger) pg_trigger_depth …Functions · System Information Functions And Operators pg_try_advisory_lockFunctionsReferencepg_try_advisory_lock System Administration Functions 10 Obtain exclusive session level advisory lock if available pg_try_advisory_lock ( key bigint ) → boolean Obtain exclusive session level…Functions · System Administration Functions pg_try_advisory_lock_sharedFunctionsReferencepg_try_advisory_lock_shared System Administration Functions 10 Obtain shared session level advisory lock if available pg_try_advisory_lock_shared ( key bigint ) → boolean Obtain shared sessi…Functions · System Administration Functions pg_try_advisory_xact_lockFunctionsReferencepg_try_advisory_xact_lock System Administration Functions 10 Obtain exclusive transaction level advisory lock if available pg_try_advisory_xact_lock ( key bigint ) → boolean Obtain exclusive…Functions · System Administration Functions pg_try_advisory_xact_lock_sharedFunctionsReferencepg_try_advisory_xact_lock_shared System Administration Functions 10 Obtain shared transaction level advisory lock if available pg_try_advisory_xact_lock_shared ( key bigint ) → boolean Obtai…Functions · System Administration Functions pg_ts_config_is_visibleFunctionsReferencepg_ts_config_is_visible System Information Functions And Operators 10 is text search configuration visible in search path pg_ts_config_is_visible ( config_oid ) → boolean is text search conf…Functions · System Information Functions And Operators pg_ts_dict_is_visibleFunctionsReferencepg_ts_dict_is_visible System Information Functions And Operators 10 is text search dictionary visible in search path pg_ts_dict_is_visible ( dict_oid ) → boolean is text search dictionary vi…Functions · System Information Functions And Operators pg_ts_parser_is_visibleFunctionsReferencepg_ts_parser_is_visible System Information Functions And Operators 10 is text search parser visible in search path pg_ts_parser_is_visible ( parser_oid ) → boolean is text search parser visi…Functions · System Information Functions And Operators pg_ts_template_is_visibleFunctionsReferencepg_ts_template_is_visible System Information Functions And Operators 10 is text search template visible in search path pg_ts_template_is_visible ( template_oid ) → boolean is text search tem…Functions · System Information Functions And Operators pg_type_is_visibleFunctionsReferencepg_type_is_visible System Information Functions And Operators 10 is type (or domain) visible in search path pg_type_is_visible ( type_oid ) → boolean is type (or domain) visible in search pa…Functions · System Information Functions And Operators pg_typeofFunctionsReferencepg_typeof System Information Functions And Operators 10 get the data type of any value pg_typeof ( any ) → regtype get the data type of any value 11 12 13 Returns the OID of the data type of…Functions · System Information Functions And Operators pg_visible_in_snapshotFunctionsReferencepg_visible_in_snapshot System Information Functions And Operators 13 Is the given transaction ID visible according to this snapshot (that is, was it completed before the snapshot was taken)?…Functions · System Information Functions And Operators pg_wal_lsn_diffFunctionsReferencepg_wal_lsn_diff System Administration Functions 10 Calculate the difference between two write-ahead log locations pg_wal_lsn_diff ( lsn pg_lsn, lsn pg_lsn ) → numeric Calculate the differenc…Functions · System Administration Functions pg_wal_replay_pauseFunctionsReferencepg_wal_replay_pause System Administration Functions 10 Pauses recovery immediately (restricted to superusers by default, but other users can be granted EXECUTE to run the function). pg_wal_r…Functions · System Administration Functions pg_wal_replay_resumeFunctionsReferencepg_wal_replay_resume System Administration Functions 10 Restarts recovery if it was paused (restricted to superusers by default, but other users can be granted EXECUTE to run the function). …Functions · System Administration Functions pg_wal_summary_contentsFunctionsReferencepg_wal_summary_contents System Information Functions And Operators 17 Returns one information about the contents of a single WAL summary file identified by TLI and starting and ending LSNs. …Functions · System Information Functions And Operators pg_walfile_nameFunctionsReferencepg_walfile_name System Administration Functions 10 Convert write-ahead log location to file name pg_walfile_name ( lsn pg_lsn ) → text Convert write-ahead log location to file name 11 12 13 …Functions · System Administration Functions pg_walfile_name_offsetFunctionsReferencepg_walfile_name_offset System Administration Functions 10 Convert write-ahead log location to file name and decimal byte offset within file pg_walfile_name_offset ( lsn pg_lsn ) → text, inte…Functions · System Administration Functions pg_xact_commit_timestampFunctionsReferencepg_xact_commit_timestamp System Information Functions And Operators 10 get commit timestamp of a transaction pg_xact_commit_timestamp ( xid ) → timestamp with time zone get commit timestamp …Functions · System Information Functions And Operators pg_xact_commit_timestamp_originFunctionsReferencepg_xact_commit_timestamp_origin System Information Functions And Operators 14 Returns the commit timestamp and replication origin of a transaction. pg_xact_commit_timestamp_origin ( xid ) → …Functions · System Information Functions And Operators pg_xact_statusFunctionsReferencepg_xact_status System Information Functions And Operators 13 Reports the commit status of a recent transaction. The result is one of in progress, committed, or aborted, provided that the tra…Functions · System Information Functions And Operators pg_xlog_location_diffFunctionsReferencepg_xlog_location_diff System Administration Functions 9.2 Calculate the difference between two transaction log locations pg_xlog_location_diff ( location text, location text ) → numeric Calc…Functions · System Administration Functions pg_xlog_replay_pauseFunctionsReferencepg_xlog_replay_pause System Administration Functions 9.1 Pauses recovery immediately. pg_xlog_replay_pause ( ) → void Pauses recovery immediately. 9.2 9.3 9.4 Pauses recovery immediately (re…Functions · System Administration Functions pg_xlog_replay_resumeFunctionsReferencepg_xlog_replay_resume System Administration Functions 9.1 Restarts recovery if it was paused. pg_xlog_replay_resume ( ) → void Restarts recovery if it was paused. 9.2 9.3 9.4 Restarts recove…Functions · System Administration Functions pg_xlogfile_nameFunctionsReferencepg_xlogfile_name System Administration Functions 9.0 Convert transaction log location string to file name pg_xlogfile_name ( location text ) → text Convert transaction log location string to…Functions · System Administration Functions pg_xlogfile_name_offsetFunctionsReferencepg_xlogfile_name_offset System Administration Functions 9.0 Convert transaction log location string to file name and decimal byte offset within file pg_xlogfile_name_offset ( location text )…Functions · System Administration Functions phraseto_tsqueryFunctionsReferencephraseto_tsquery Text Search Functions And Operators 10 produce tsquery that searches for a phrase, ignoring punctuation phraseto_tsquery ( [ config regconfig , ] query text ) → tsquery prod…Functions · Text Search Functions And Operators piFunctionsReferencepi Mathematical Functions And Operators 10 “π” constant pi ( ) → dp “π” constant 11 12 13 Approximate value of π pi ( ) → double precision Approximate value of π 14 15 16 17 18 19 20 9.0 "π"…Functions · Mathematical Functions And Operators plainto_tsqueryFunctionsReferenceplainto_tsquery Text Search Functions And Operators 10 produce tsquery ignoring punctuation plainto_tsquery ( [ config regconfig , ] query text ) → tsquery produce tsquery ignoring punctuati…Functions · Text Search Functions And Operators pointFunctionsReferencepoint Geometric Functions And Operators 10 construct point point ( double precision, double precision ) → point construct point point ( box ) → point center of box point ( circle ) → point c…Functions · Geometric Functions And Operators polygonFunctionsReferencepolygon Geometric Functions And Operators 10 box to 4-point polygon polygon ( box ) → polygon box to 4-point polygon polygon ( circle ) → polygon circle to 12-point polygon polygon ( npts, c…Functions · Geometric Functions And Operators popenFunctionsReferencepopen Geometric Functions And Operators 10 convert path to open popen ( path ) → path convert path to open 11 12 13 Converts path to open form. popen ( path ) → path Converts path to open fo…Functions · Geometric Functions And Operators populate_recordFunctionsPG18populate_record ( anyelement, hstore ) → anyelement Replaces fields in the left operand (which must be a composite type) with matching values from hstore. populate_record(ROW(1,2), 'f1=>42':…hstore — hstore key/value datatype › hstore Operators and Functions positionFunctionsReferenceposition String Functions And Operators 10 Location of specified substring position ( substring in string ) → int Location of specified substring 11 12 13 Returns first starting index of the…Functions · String Functions And Operators powFunctionsPG18pow ( x, y ) → double power ( x, y ) → double x raised to the power of y pow(2.0, 10) → 1024.0pgbench › Notes › Built-In Functions powerFunctionsReferencepower Mathematical Functions And Operators 10 a raised to the power of b power ( a dp, b dp ) → dp a raised to the power of b power ( a numeric, b numeric ) → numeric a raised to the power o…Functions · Mathematical Functions And Operators query_to_xmlFunctionsReferencequery_to_xml Xml Functions 10 The return type of each function is xml. query_to_xml(query text, nulls boolean, tableforest boolean, targetns text) The return type of each function is xml. 11…Functions · Xml Functions query_to_xml_and_xmlschemaFunctionsReferencequery_to_xml_and_xmlschema Xml Functions 10 In addition, the following functions are available to produce analogous mappings of entire schemas or the entire current database: query_to_xml_an…Functions · Xml Functions query_to_xmlschemaFunctionsReferencequery_to_xmlschema Xml Functions 10 It is essential that the same parameters are passed in order to obtain matching XML data mappings and XML Schema documents. query_to_xmlschema(query text,…Functions · Xml Functions querytreeFunctionsReferencequerytree Text Search Functions And Operators 10 get indexable part of a tsquery querytree ( query tsquery ) → text get indexable part of a tsquery 11 12 13 Produces a representation of the …Functions · Text Search Functions And Operators