PostgreSQL Function Reference

String functions

CHR CONCAT LENGTH LOWER LPAD LTRIM POSITION REPEAT REPLACE REVERSE RPAD RTRIM 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