Search PostgreSQL documentation

networkFunctionsReferencenetwork Network Address Functions And Operators 10 extract network part of address network ( inet ) → cidr extract network part of address 11 12 13 Returns the network part of the address, z…Functions · Network Address Functions And Operators nextvalFunctionsReferencenextval Sequence Manipulation Functions 10 Advance sequence and return new value nextval ( regclass ) → bigint Advance sequence and return new value 11 12 13 Advances the sequence object to …Functions · Sequence Manipulation Functions nlevelFunctionsPG18nlevel ( ltree ) → integer Returns number of labels in path. nlevel('Top.Child1.Child2') → 3ltree — hierarchical tree-like data type › Operators and Functions normal_randFunctionsPG18normal_rand ( numvals integer, mean float8, stddev float8 ) → setof float8 Produces a set of normally distributed random values.tablefunc — functions that return tables (crosstab and others) › Functions Provided normalizeFunctionsReferencenormalize String Functions And Operators 13 Converts the string to the specified Unicode normalization form. The optional form key word specifies the form: NFC (the default), NFD, NFKC, or N…Functions · String Functions And Operators nowFunctionsReferencenow Date/Time Functions And Operators 10 Current date and time (start of current transaction); see Section 9.9.4 now ( ) → timestamp with time zone Current date and time (start of current tr…Functions · Date/Time Functions And Operators npointsFunctionsReferencenpoints Geometric Functions And Operators 10 number of points npoints ( path ) → int number of points npoints ( polygon ) → int number of points 11 12 13 Returns the number of points. Availa…Functions · Geometric Functions And Operators nth_valueFunctionsReferencenth_value Window Functions 10 returns value evaluated at the row that is the nth row of the window frame (counting from 1); null if no such row nth_value ( value any, nth integer ) → same ty…Functions · Window Functions ntileFunctionsReferencentile Window Functions 10 integer ranging from 1 to the argument value, dividing the partition as equally as possible ntile ( num_buckets integer ) → integer integer ranging from 1 to the ar…Functions · Window Functions NULLIFFunctionsReferenceNULLIF Conditional Expressions 10 The NULLIF function returns a null value if value1 equals value2; otherwise it returns value1. This can be used to perform the inverse operation of the COAL…Functions · Conditional Expressions num_nonnullsFunctionsReferencenum_nonnulls Comparison Functions And Operators 10 returns the number of non-null arguments num_nonnulls ( VARIADIC "any" ) returns the number of non-null arguments 11 12 13 Returns the numb…Functions · Comparison Functions And Operators num_nullsFunctionsReferencenum_nulls Comparison Functions And Operators 10 returns the number of null arguments num_nulls ( VARIADIC "any" ) returns the number of null arguments 11 12 13 Returns the number of null arg…Functions · Comparison Functions And Operators numnodeFunctionsReferencenumnode Text Search Functions And Operators 10 number of lexemes plus operators in tsquery numnode ( tsquery ) → integer number of lexemes plus operators in tsquery 11 12 13 Returns the numb…Functions · Text Search Functions And Operators obj_descriptionFunctionsReferenceobj_description System Information Functions And Operators 10 get comment for a database object obj_description ( object_oid, catalog_name ) → text get comment for a database object obj_desc…Functions · System Information Functions And Operators octet_lengthFunctionsReferenceoctet_length String Functions And Operators 10 Number of bytes in string octet_length ( string ) → int Number of bytes in string 11 12 13 Returns number of bytes in the string. octet_length …Functions · String Functions And Operators overlayFunctionsReferenceoverlay String Functions And Operators 10 Replace substring overlay ( string placing string from int [for int] ) → text Replace substring overlay ( string placing string from int [for int] )…Functions · String Functions And Operators parse_identFunctionsReferenceparse_ident String Functions And Operators 10 Split qualified_identifier into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the …Functions · String Functions And Operators pathFunctionsReferencepath Geometric Functions And Operators 10 polygon to path path ( polygon ) → path polygon to path 11 12 13 Converts polygon to a closed path with the same list of points. path ( polygon ) → …Functions · Geometric Functions And Operators pcloseFunctionsReferencepclose Geometric Functions And Operators 10 convert path to closed pclose ( path ) → path convert path to closed 11 12 13 Converts path to closed form. pclose ( path ) → path Converts path t…Functions · Geometric Functions And Operators percent_rankFunctionsReferencepercent_rank Aggregate Functions 10 relative rank of the hypothetical row, ranging from 0 to 1 percent_rank ( args ) WITHIN GROUP (ORDER BY sorted_args) → double precision relative rank of t…Functions · Aggregate Functions percentile_contFunctionsReferencepercentile_cont Aggregate Functions 10 continuous percentile: returns a value corresponding to the specified fraction in the ordering, interpolating between adjacent input items if needed pe…Functions · Aggregate Functions percentile_discFunctionsReferencepercentile_disc Aggregate Functions 10 discrete percentile: returns the first input value whose position in the ordering equals or exceeds the specified fraction percentile_disc ( fraction )…Functions · Aggregate Functions permuteFunctionsPG18permute ( i, size [, seed ] ) → integer Permuted value of i, in the range [0, size). This is the new position of i (modulo size) in a pseudorandom permutation of the integers 0...size-1, par…pgbench › Notes › Built-In Functions pg_advisory_lockFunctionsReferencepg_advisory_lock System Administration Functions 10 Obtain exclusive session level advisory lock pg_advisory_lock ( key bigint ) → void Obtain exclusive session level advisory lock pg_adviso…Functions · System Administration Functions pg_advisory_lock_sharedFunctionsReferencepg_advisory_lock_shared System Administration Functions 10 Obtain shared session level advisory lock pg_advisory_lock_shared ( key bigint ) → void Obtain shared session level advisory lock p…Functions · System Administration Functions pg_advisory_unlockFunctionsReferencepg_advisory_unlock System Administration Functions 10 Release an exclusive session level advisory lock pg_advisory_unlock ( key bigint ) → boolean Release an exclusive session level advisory…Functions · System Administration Functions pg_advisory_unlock_allFunctionsReferencepg_advisory_unlock_all System Administration Functions 10 Release all session level advisory locks held by the current session pg_advisory_unlock_all ( ) → void Release all session level adv…Functions · System Administration Functions pg_advisory_unlock_sharedFunctionsReferencepg_advisory_unlock_shared System Administration Functions 10 Release a shared session level advisory lock pg_advisory_unlock_shared ( key bigint ) → boolean Release a shared session level ad…Functions · System Administration Functions pg_advisory_xact_lockFunctionsReferencepg_advisory_xact_lock System Administration Functions 10 Obtain exclusive transaction level advisory lock pg_advisory_xact_lock ( key bigint ) → void Obtain exclusive transaction level advis…Functions · System Administration Functions pg_advisory_xact_lock_sharedFunctionsReferencepg_advisory_xact_lock_shared System Administration Functions 10 Obtain shared transaction level advisory lock pg_advisory_xact_lock_shared ( key bigint ) → void Obtain shared transaction lev…Functions · System Administration Functions pg_available_wal_summariesFunctionsReferencepg_available_wal_summaries System Information Functions And Operators 17 Returns information about the WAL summary files present in the data directory, under pg_wal/summaries. One row will b…Functions · System Information Functions And Operators pg_backend_pidFunctionsReferencepg_backend_pid System Information Functions And Operators 10 Process ID of the server process attached to the current session pg_backend_pid ( ) → int Process ID of the server process attach…Functions · System Information Functions And Operators pg_backup_startFunctionsReferencepg_backup_start System Administration Functions 15 Prepares the server to begin an on-line backup. The only required parameter is an arbitrary user-defined label for the backup. (Typically t…Functions · System Administration Functions pg_backup_start_timeFunctionsReferencepg_backup_start_time System Administration Functions 10 Get start time of an on-line exclusive backup in progress. pg_backup_start_time ( ) → timestamp with time zone Get start time of an on…Functions · System Administration Functions pg_backup_stopFunctionsReferencepg_backup_stop System Administration Functions 15 Finishes performing an on-line backup. The desired contents of the backup label file and the tablespace map file are returned as part of the…Functions · System Administration Functions pg_basetypeFunctionsReferencepg_basetype System Information Functions And Operators 17 Returns the OID of the base type of a domain identified by its type OID. If the argument is the OID of a non-domain type, returns th…Functions · System Information Functions And Operators pg_blocking_pidsFunctionsReferencepg_blocking_pids System Information Functions And Operators 10 Process ID(s) that are blocking specified server process ID from acquiring a lock pg_blocking_pids ( int ) → int[] Process ID(s…Functions · System Information Functions And Operators pg_cancel_backendFunctionsReferencepg_cancel_backend System Administration Functions 10 Cancel a backend's current query. This is also allowed if the calling role is a member of the role whose backend is being canceled or the…Functions · System Administration Functions pg_char_to_encodingFunctionsReferencepg_char_to_encoding System Information Functions And Operators 15 Converts the supplied encoding name into an integer representing the internal identifier used in some system catalog tables.…Functions · System Information Functions And Operators pg_clear_attribute_statsFunctionsReferencepg_clear_attribute_stats System Administration Functions 18 Clears column-level statistics for the given relation and attribute, as though the table was newly created. pg_clear_attribute_sta…Functions · System Administration Functions