↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Functions

array_to_string

Converts each array element to its text representation, and concatenates those separated by the delimiter string. If null_string is given and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted. See also string_to_array.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

group
array
group label
Array Functions And Operators
lang
en
layout
table-new
pages
functions-array.html
prose only
false

Definition PG 18

Converts each array element to its text representation, and concatenates those separated by the delimiter string. If null_string is given and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted. See also string_to_array.

Signatures and overloads

array_to_string ( array anyarray, delimiter text [, null_string text ] ) → text → text
Converts each array element to its text representation, and concatenates those separated by the delimiter string. If null_string is given and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted. See also string_to_array.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:bf872336644b9026cb463d7593c9aaa663fa759eba10ccade699221339fb418e

Text language: en · wiki-repair-20261023:bf872336644b9026cb463d7593c9aaa663fa759eba10ccade699221339fb418e