PostgreSQL Reference
Browse PostgreSQL reference pages by topic: administration, aggregate and window functions, arrays, data types, date and time, enums, geometry, JSON, math, ranges, sequences, sessions, set-returning functions, and strings. For task-based query guides, see PostgreSQL Basics; for SQLSTATE troubleshooting, use the PostgreSQL error index.
-
PostgreSQL String Functions
- ascii
- bit_length
- btrim
- char_length
- character_length
- chr
- concat
- concat_ws
- format
- initcap
- left
- length
- lower
- ltrim
- md5
- normalize
- octet_length
- overlay
- parse_ident
- pg_client_encoding
- position
- quote_ident
- quote_literal
- quote_nullable
- regexp_match
- regexp_matches
- regexp_replace
- regexp_split_to_array
- regexp_split_to_table
- repeat
- replace
- reverse
- right
- rpad
- rtrim
- split_part
- starts_with
- string_to_array
- string_to_table
- strpos
- substr
- substring
- to_ascii
- to_char
- to_hex
- to_number
- translate
- trim
- unistr
- upper
-
PostgreSQL Math Functions
-
PostgreSQL Date and Time Functions
- age
- clock_timestamp
- current_date
- current_time
- current_timestamp
- date_bin
- date_part
- date_trunc
- extract
- isfinite
- justify_days
- justify_hours
- justify_interval
- localtime
- localtimestamp
- make_date
- make_interval
- make_time
- make_timestamp
- make_timestamptz
- now
- pg_sleep
- pg_sleep_for
- pg_sleep_until
- statement_timestamp
- timeofday
- to_date
- to_timestamp
- transaction_timestamp
-
PostgreSQL Array Functions
-
PostgreSQL JSON Functions
- array_to_json
- json_array_elements
- json_array_elements_text
- json_array_length
- json_build_array
- json_build_object
- json_each
- json_each_text
- json_extract_path
- json_extract_path_text
- json_object
- json_object_keys
- json_populate_record
- json_populate_recordset
- json_strip_nulls
- json_to_record
- json_to_recordset
- json_typeof
- jsonb_array_elements
- jsonb_array_elements_text
- jsonb_array_length
- jsonb_build_array
- jsonb_build_object
- jsonb_each
- jsonb_each_text
- jsonb_extract_path
- jsonb_extract_path_text
- jsonb_insert
- jsonb_object
- jsonb_object_keys
- jsonb_path_exists
- jsonb_path_exists_tz
- jsonb_path_match
- jsonb_path_match_tz
- jsonb_path_query
- jsonb_path_query_array
- jsonb_path_query_array_tz
- jsonb_path_query_first
- jsonb_path_query_first_tz
- jsonb_path_query_tz
- jsonb_populate_record
- jsonb_populate_recordset
- jsonb_pretty
- jsonb_set
- jsonb_set_lax
- jsonb_strip_nulls
- jsonb_to_record
- jsonb_to_recordset
- jsonb_typeof
- row_to_json
- to_json
- to_jsonb
-
PostgreSQL Sequence Functions
-
PostgreSQL Enum Functions
-
PostgreSQL Range Functions
-
PostgreSQL Set Returning Functions
-
PostgreSQL Data Types Reference
-
PostgreSQL Aggregate Functions
-
PostgreSQL Geometry Functions
- area()
- bound_box()
- box(circle)
- box(point,point)
- box(point)
- box(polygon)
- center()
- circle()
- circle(box)
- circle(polygon)
- diagonal()
- diameter()
- height()
- isclosed()
- isopen()
- line()
- lseg(box)
- lseg(point,point)
- npoints()
- path(polygon)
- pclose()
- point()
- point(box)
- point(circle)
- point(lseg)
- point(polygon)
- polygon(box)
- polygon(circle)
- polygon(integer, circle)
- polygon(path)
- popen()
- radius()
- slope()
- ST_Length()
- width()
-
PostgreSQL Session Functions
- current_catalog
- current_database
- current_query
- current_role
- current_schema
- current_schemas
- current_user
- inet_client_port
- inet_server_addr
- inet_server_port
- pg_backend_pid
- pg_blocking_pids
- pg_conf_load_time
- pg_current_logfile
- pg_is_other_temp_schema
- pg_jit_available
- pg_listening_channels
- pg_my_temp_schema
- pg_notification_queue_usage
- pg_postmaster_start_time
- pg_trigger_depth
- user
- version
-
PostgreSQL Window Functions