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.

To reformat a PostgreSQL query in your browser, use the SQL formatter. The PostgreSQL dialect is selected for you; the query stays in your browser and formatting does not execute or validate it.

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
- abs
- acos
- acosd
- acosh
- asin
- asind
- asinh
- atan
- atan2
- atan2d
- atand
- atanh
- cbrt
- ceil
- ceiling
- cos
- cosd
- cosh
- cot
- cotd
- degrees
- div
- exp
- factorial
- floor
- gcd
- lcm
- ln
- log
- log10
- min_scale
- mod
- pi
- power
- radians
- random
- round
- scale
- setseed
- sign
- sin
- sind
- sinh
- sqrt
- tan
- tand
- tanh
- trim_scale
- trunc
- width_bucket
PostgreSQL Date and Time Functions
PostgreSQL Array Functions
PostgreSQL JSON Functions
PostgreSQL Sequence Functions
- currval
- lastval
- nextval
- setval
PostgreSQL Enum Functions
PostgreSQL Range Functions
- isempty()
- lower_inc()
- lower_inf()
- lower()
- multirange()
- range_merge()
- unnest()
- upper_inc()
- upper_inf()
- upper()
PostgreSQL Set Returning Functions
- generate_series
- generate_subscripts
PostgreSQL Data Types Reference
- bigint
- bigserial
- boolean
- box
- char
- cidr
- circle
- citext
- date
- decimal
- double precision
- enum
- inet
- integer
- interval
- json
- jsonb
- line
- lseg
- numeric
- path
- point
- polygon
- real
- serial
- smallint
- text
- time
- timestamp
- timestamptz
- timetz
- uuid
- varchar
PostgreSQL Aggregate Functions
- array_agg
- avg
- bit_and
- bit_or
- bit_xor
- bool_and
- bool_or
- count
- every
- json_agg
- json_object_agg
- jsonb_agg
- jsonb_object_agg
- max
- min
- range_agg
- range_intersect_agg
- stddev
- stddev_pop
- stddev_samp
- string_agg
- sum
- var_pop
- var_samp
- variance
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
PostgreSQL Window Functions
- cume_dist
- dense_rank
- first_value
- lag
- last_value
- lead
- nth_value
- ntile
- percent_rank
- rank
- row_number