Database files

PostgreSQL array literal builder

Build rectangular text-array literals while preserving null versus "NULL".

Your inputs

Start with an example

Your inputs stay in your browser.

Your result

Example result

How it works

Quote all text cells, escape backslashes/double quotes and use unquoted NULL for null cells. Check matching nested dimensions.

The example becomes {{"a",NULL},{"b","NULL"}}: a two-dimensional array with four cells.

Limits

Text elements only, with at most six dimensions. Empty arrays are accepted only at the top level. This is an array data literal, not an SQL string literal; no query is run.