PostgreSQL Function Reference — SQL Academy

String functions

CHAR_LENGTH CHR CONCAT CONCAT_WS FORMAT INITCAP LEFT LENGTH LOWER LPAD LTRIM OCTET_LENGTH POSITION REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SPLIT_PART STRPOS SUBSTR SUBSTRING TRANSLATE TRIM UPPER

Numeric functions

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

Date and time functions

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

Aggregate functions

ARRAY_AGG AVG BOOL_AND BOOL_OR COUNT FILTER MAX MIN PERCENTILE_CONT PERCENTILE_DISC STDDEV_SAMP STRING_AGG SUM VAR_SAMP

Window functions

CUME_DIST DENSE_RANK FIRST_VALUE LAG LAST_VALUE LEAD NTH_VALUE NTILE PERCENT_RANK RANK ROW_NUMBER ROWS BETWEEN

Regular expression functions

REGEXP_COUNT REGEXP_INSTR REGEXP_LIKE REGEXP_MATCH REGEXP_MATCHES REGEXP_REPLACE REGEXP_SPLIT_TO_TABLE REGEXP_SUBSTR

Conditions and constructs

->->>::ARRAY_LENGTH CASE CAST COALESCE DISTINCT ON GENERATE_SERIES JSONB_BUILD_OBJECT JSONB_EXTRACT_PATH_TEXT NULLIF UNNEST WITH