Table of Contents


Ispirer Website Ispirer Capabilities - PostgreSQL Migration Free Trial

PostgreSQL - SQL Functions Mapping to Other Databases

Numeric Functions Mapping

PostgreSQL Oracle SQL Server IBM DB2 MySQL
ABS ABS ABS ABS ABS
ACOS ACOS ACOS ACOS ACOS
ASIN ASIN ASIN ASIN ASIN
ATAN ATAN ATAN ATAN ATAN
ATAN2 ATAN2 ATN2 ATAN2 ATAN2
CBRT
CEIL CEIL CEILING CEILING CEILING
COS COS COS COS COS
COT COT COT COT
DEGREES DEGREES DEGREES DEGREES
DIV DIV
EXP EXP EXP EXP EXP
FLOOR FLOOR FLOOR FLOOR FLOOR
LN LN LOG LN LN
LOG LOG LOG10 LOG10 LOG10
MOD MOD MOD MOD
PI PI PI
POWER POWER POWER POWER POWER
RADIANS RADIANS RADIANS RADIANS
RANDOM RAND RAND RAND
ROUND ROUND (number) ROUND ROUND ROUND
SIGN SIGN SIGN SIGN SIGN
SIN SIN SIN SIN SIN
SQRT SQRT SQRT SQRT SQRT
TAN TAN TAN TAN TAN
TRUNC TRUNC (number) TRUNCATE TRUNCATE

String Functions Mapping

PostgreSQL Oracle SQL Server IBM DB2 MySQL
ASCII ASCII ASCII ASCII ASCII
BIT_LENGTH BIT_COUNT
BTRIM TRIM STRIP TRIM
CHR CHR CHAR CHR CHAR
GET_BIT
GET_BYTE
INITCAP INITCAP
LENGTH LENGTH LEN LENGTH CHAR_LENGTH
CHAR_LENGTH LENGTH LEN LENGTH CHAR_LENGTH
LOWER LOWER LOWER LCASE LOWER
LPAD LPAD LPAD
LTRIM LTRIM LTRIM LTRIM LTRIM
OCTET_LENGTH LENGTH LEN LENGTH CHAR_LENGTH
OVERLAY STUFF INSERT INSERT
POSITION INSTR CHARINDEX LOCATE INSTR
QUOTE_IDENT QUOTENAME
QUOTE_LITERAL QUOTE
REGEXP_MATCHES REGEXP_SUBSTR
REGEXP_REPLACE REGEXP_REPLACE
REGEXP_SPLIT_TO_TABLE
REGEXP_SPLIT_TO_TO_ARRAY
REPEAT REPLICATE REPEAT REPEAT
REPLACE REPLACE REPLACE REPLACE REPLACE
RPAD RPAD RPAD
RTRIM RTRIM RTRIM RTRIM RTRIM
SET_BIT
SET_BYTE
SPLIT_PART
STRPOS INSTR CHARINDEX LOCATE INSTR
SUBSTR SUBSTR SUBSTRING SUBSTR SUBSTR
TRANSLATE TRANSLATE TRANSLATE
TRIM TRIM STRIP TRIM
UPPER UPPER UPPER UCASE UPPER