PostgreSQL Function Reference

String functions

CHR CONCAT LENGTH LOWER LPAD LTRIM POSITION REPEAT REPLACE REVERSE RPAD RTRIM SPLIT_PART SUBSTRING TRIM UPPER

Numeric functions

ABS CEIL COS EXP FLOOR GREATEST LEAST LOG MOD PI POWER RANDOM ROUND SIGN SIN SQRT TAN TRUNC

Date and time functions

AGE CURRENT_DATE CURRENT_TIME DATE DATE_PART DATE_TRUNC EXTRACT MAKE_DATE MAKE_INTERVAL MAKE_TIME NOW TO_CHAR TO_DATE TO_TIMESTAMP

Window functions

DENSE_RANK FIRST_VALUE LAG LAST_VALUE LEAD RANK ROW_NUMBER

Aggregate functions

AVG COUNT MAX MIN STRING_AGG SUM

Advanced functions

CAST COALESCE NULLIF WITH