PostgreSQL Functions [Ispirer Migration Knowledge Base]

Ispirer Website Ispirer Capabilities - PostgreSQL Migration Free Trial

PostgreSQL Functions

SQL Functions Mapping to Other Databases
Numeric Functions
- ABS
- ACOS
- ASIN
- ATAN
- ATAN2
- CBRT
- CEIL
- COS
- COT
- DEGREES
- DIV
- EXP
- FLOOR
- LN
- LOG
- MOD
- PI
- POWER
- RADIANS
- RANDOM
- ROUND
- SIGN
- SIN
- SQRT
- TAN
- TRUNC
String Functions
- ASCII
- BIT_LENGTH
- BTRIM
- CHR
- GET_BIT
- GET_BYTE
- INITCAP
- LENGTH
- CHAR_LENGTH
- LOWER
- LPAD
- LTRIM
- OCTET_LENGTH
- OVERLAY
- POSITION
- QUOTE_IDENT
- QUOTE_LITERAL
- REGEXP_MATCHES
- REGEXP_REPLACE
- REGEXP_SPLIT_TO_TABLE
- REGEXP_SPLIT_TO_TO_ARRAY
- REPEAT
- REPLACE
- RPAD
- RTRIM
- SET_BIT
- SET_BYTE
- SPLIT_PART
- STRPOS
- SUBSTR
- TRANSLATE
- TRIM
- UPPER
Date and Time Functions
Analitic and Aggregate Functions
- ARRAY_AGG
- AVG
- BIT_AND
- BIT_OR
- BOOL_AND
- BOOL_OR
- CORR
- COUNT
- COVAR_POP
- COVAR_SAMP
- EVERY
- MAX
- MIN
- REGR_AVGX
- REGR_AVGY
- REGR_COUNT
- REGR_INTERCEPT
- REGR_R2
- REGR_SLOPE
- REGR_SXX
- REGR_SXY
- REGR_SYY
- STDDEV
- STDDEV_POP
- STDDEV_SAMP
- SUM
- VAR_POP
- VAR_SAMP
- VARIANCE
- XMLAGG
- WIDTH_BUCKET
Conversion Functions
- TO_CHAR
- TO_DATE
- TO_TIMESTAMP
- CONVERT
- CONVERT_FROM
- CONVERT_TO
- DECODE
- ENCODE
- TO_ASCII
- TO_HEX
XML Functions
- CURSOR_TO_XML
- QUERY_TO_XML
- TABLE_TO_XML
- XMLAGG
- XMLCOMMENT
- XMLCONCAT
- XMLELEMENT
- XMLFOREST
- XMLPI
- XMLROOT
- XPATH