Search PostgreSQL documentation

row_to_jsonFunctionsReferencerow_to_json Json Functions And Operators 10 Returns the row as a JSON object. Line feeds will be added between level-1 elements if pretty_bool is true. row_to_json ( record [, pretty_bool] )…Functions · Json Functions And Operators rpadFunctionsReferencerpad String Functions And Operators 10 Fill up the string to length length by appending the characters fill (a space by default). If the string is already longer than length then it is trunc…Functions · String Functions And Operators rtrimFunctionsReferencertrim String Functions And Operators 10 Remove the longest string containing only characters from characters (a space by default) from the end of string rtrim ( string text [, characters tex…Functions · String Functions And Operators scaleFunctionsReferencescale Mathematical Functions And Operators 10 scale of the argument (the number of decimal digits in the fractional part) scale ( numeric ) → integer scale of the argument (the number of dec…Functions · Mathematical Functions And Operators schema_to_xmlFunctionsReferenceschema_to_xml Xml Functions 10 Note that these potentially produce a lot of data, which needs to be built up in memory. When requesting content mappings of large schemas or databases, it mig…Functions · Xml Functions schema_to_xml_and_xmlschemaFunctionsReferenceschema_to_xml_and_xmlschema Xml Functions 10 Note that these potentially produce a lot of data, which needs to be built up in memory. When requesting content mappings of large schemas or dat…Functions · Xml Functions schema_to_xmlschemaFunctionsReferenceschema_to_xmlschema Xml Functions 10 Note that these potentially produce a lot of data, which needs to be built up in memory. When requesting content mappings of large schemas or databases, …Functions · Xml Functions sec_to_gcFunctionsPG18sec_to_gc ( float8 ) → float8 Converts the normal straight line (secant) distance between two points on the surface of the Earth to the great circle distance between them.earthdistance — calculate great-circle distances › Cube-Based Earth Distances sepgsql_getconFunctionsPG18sepgsql_getcon () → text Returns the client domain, the current security label of the client.sepgsql — SELinux-, label-based mandatory access control (MAC) security module › Sepgsql Functions sepgsql_mcstrans_inFunctionsPG18sepgsql_mcstrans_in ( text ) → text Translates the given qualified MLS/MCS range into raw format if the mcstrans daemon is running.sepgsql — SELinux-, label-based mandatory access control (MAC) security module › Sepgsql Functions sepgsql_mcstrans_outFunctionsPG18sepgsql_mcstrans_out ( text ) → text Translates the given raw MLS/MCS range into qualified format if the mcstrans daemon is running.sepgsql — SELinux-, label-based mandatory access control (MAC) security module › Sepgsql Functions sepgsql_restoreconFunctionsPG18sepgsql_restorecon ( text ) → boolean Sets up initial security labels for all objects within the current database. The argument may be NULL, or the name of a specfile to be used as alternati…sepgsql — SELinux-, label-based mandatory access control (MAC) security module › Sepgsql Functions sepgsql_setconFunctionsPG18sepgsql_setcon ( text ) → boolean Switches the client domain of the current session to the new domain, if allowed by the security policy. It also accepts NULL input as a request to transitio…sepgsql — SELinux-, label-based mandatory access control (MAC) security module › Sepgsql Functions session_userFunctionsReferencesession_user System Information Functions And Operators 10 session user name session_user → name session user name 11 12 13 Returns the session user's name. session_user → name Returns the s…Functions · System Information Functions And Operators set_bitFunctionsReferenceset_bit Binary String Functions And Operators 10 Set bit in string set_bit ( string, offset, newvalue ) → bytea Set bit in string 11 12 13 Sets n'th bit in binary string to newvalue. set_bit…Functions · Binary String Functions And Operators set_byteFunctionsReferenceset_byte Binary String Functions And Operators 10 Set byte in string set_byte ( string, offset, newvalue ) → bytea Set byte in string 11 12 13 Sets n'th byte in binary string to newvalue. se…Functions · Binary String Functions And Operators set_configFunctionsReferenceset_config System Administration Functions 10 set parameter and return new value set_config ( setting_name, new_value, is_local ) → text set parameter and return new value 11 12 13 Sets the …Functions · System Administration Functions set_limitFunctionsPG18set_limit ( real ) → real Sets the current similarity threshold that is used by the % operator. The threshold must be between 0 and 1 (default is 0.3). Returns the same value passed in. (Dep…pg_trgm — support for similarity of text using trigram matching › Functions and Operators set_masklenFunctionsReferenceset_masklen Network Address Functions And Operators 10 set netmask length for inet value set_masklen ( inet, int ) → inet set netmask length for inet value set_masklen ( cidr, int ) → cidr s…Functions · Network Address Functions And Operators setseedFunctionsReferencesetseed Mathematical Functions And Operators 10 set seed for subsequent random() calls (value between -1.0 and 1.0, inclusive) setseed ( dp ) → void set seed for subsequent random() calls (v…Functions · Mathematical Functions And Operators setvalFunctionsReferencesetval Sequence Manipulation Functions 10 Set sequence's current value setval ( regclass, bigint ) → bigint Set sequence's current value setval ( regclass, bigint, boolean ) → bigint Set seq…Functions · Sequence Manipulation Functions setweightFunctionsReferencesetweight Text Search Functions And Operators 10 assign weight to each element of vector setweight ( vector tsvector, weight "char" ) → tsvector assign weight to each element of vector setwe…Functions · Text Search Functions And Operators sha224FunctionsReferencesha224 Binary String Functions And Operators 11 SHA-224 hash sha224 ( bytea ) → bytea SHA-224 hash 12 13 Computes the SHA-224 hash of the binary string. sha224 ( bytea ) → bytea Computes the…Functions · Binary String Functions And Operators sha256FunctionsReferencesha256 Binary String Functions And Operators 11 SHA-256 hash sha256 ( bytea ) → bytea SHA-256 hash 12 13 Computes the SHA-256 hash of the binary string. sha256 ( bytea ) → bytea Computes the…Functions · Binary String Functions And Operators sha384FunctionsReferencesha384 Binary String Functions And Operators 11 SHA-384 hash sha384 ( bytea ) → bytea SHA-384 hash 12 13 Computes the SHA-384 hash of the binary string. sha384 ( bytea ) → bytea Computes the…Functions · Binary String Functions And Operators sha512FunctionsReferencesha512 Binary String Functions And Operators 11 SHA-512 hash sha512 ( bytea ) → bytea SHA-512 hash 12 13 Computes the SHA-512 hash of the binary string. sha512 ( bytea ) → bytea Computes the…Functions · Binary String Functions And Operators shobj_descriptionFunctionsReferenceshobj_description System Information Functions And Operators 10 get comment for a shared database object shobj_description ( object_oid, catalog_name ) → text get comment for a shared databa…Functions · System Information Functions And Operators show_limitFunctionsPG18show_limit () → real Returns the current similarity threshold used by the % operator. This sets the minimum similarity between two words for them to be considered similar enough to be misspe…pg_trgm — support for similarity of text using trigram matching › Functions and Operators show_trgmFunctionsPG18show_trgm ( text ) → text[] Returns an array of all the trigrams in the given string. (In practice this is seldom useful except for debugging.)pg_trgm — support for similarity of text using trigram matching › Functions and Operators signFunctionsReferencesign Mathematical Functions And Operators 10 sign of the argument (-1, 0, +1) sign ( dp or numeric ) → (same as input) sign of the argument (-1, 0, +1) 11 12 13 Sign of the argument (-1, 0, …Functions · Mathematical Functions And Operators similarityFunctionsPG18similarity ( text, text ) → real Returns a number that indicates how similar the two arguments are. The range of the result is zero (indicating that the two strings are completely dissimilar…pg_trgm — support for similarity of text using trigram matching › Functions and Operators sinFunctionsReferencesin Mathematical Functions And Operators 10 sine sin ( x ) sine 11 12 13 Sine, argument in radians sin ( double precision ) → double precision Sine, argument in radians 14 15 16 17 18 19 20 …Functions · Mathematical Functions And Operators sindFunctionsReferencesind Mathematical Functions And Operators 10 sine sind ( x ) sine 11 12 13 Sine, argument in degrees sind ( double precision ) → double precision Sine, argument in degrees 14 15 16 17 18 19 …Functions · Mathematical Functions And Operators sinhFunctionsReferencesinh Mathematical Functions And Operators 12 hyperbolic sine sinh ( x ) hyperbolic sine 13 Hyperbolic sine sinh ( double precision ) → double precision Hyperbolic sine 14 15 16 17 18 19 20Functions · Mathematical Functions And Operators skeysFunctionsPG18skeys ( hstore ) → setof text Extracts an hstore's keys as a set. skeys('a=>1,b=>2') → a bhstore — hstore key/value datatype › hstore Operators and Functions sliceFunctionsPG18slice ( hstore, text[] ) → hstore Extracts a subset of an hstore containing only the specified keys. slice('a=>1,b=>2,c=>3'::hstore, ARRAY['b','c','x']) → "b"=>"2", "c"=>"3"hstore — hstore key/value datatype › hstore Operators and Functions slopeFunctionsReferenceslope Geometric Functions And Operators 13 Computes slope of a line drawn through the two points. slope ( point, point ) → double precision Computes slope of a line drawn through the two poi…Functions · Geometric Functions And Operators sortFunctionsPG18sort ( integer[], dir text ) → integer[] Sorts the array in either ascending or descending order. dir must be asc or desc. sort('{1,3,2}'::integer[], 'desc') → {3,2,1}intarray — manipulate arrays of integers › intarray Functions and Operators sort_ascFunctionsPG18sort ( integer[] ) → integer[] sort_asc ( integer[] ) → integer[] Sorts in ascending order. sort(array[11,77,44]) → {11,44,77}intarray — manipulate arrays of integers › intarray Functions and Operators sort_descFunctionsPG18sort_desc ( integer[] ) → integer[] Sorts in descending order. sort_desc(array[11,77,44]) → {77,44,11}intarray — manipulate arrays of integers › intarray Functions and Operators