ARRAY
keyword after the data type of the elements:
ARRAY
keyword and combining it with the array’s values enclosed in square brackets and separated by commas:
SELECT
or INSERT INTO
statements:
INSERT INTO
statements with the VALUES
clause:
1
and end at index n
:
NULL
lower_bound:upper_bound
. The bounds can be omitted, in which case the slice is unbounded from a given side:
ORDER BY
, GROUP BY
or JOIN
operations. It is also impossible to use the array columns as a part of the index of a table. For all the operations mentioned above, an appropriate error message will be returned:
ORDER BY
or JOIN
operations, if the array column is not the key:
INSERT INTO
with SELECT
: Arrays cannot be directly imported using an INSERT INTO
with a SELECT
statement. Instead, we encourage you to either use the COPY FROM CSV
command or the INSERT INTO
statement with the VALUES
keywordUPDATE
and DELETE
: Updating or deleting records from a table, which contains array columns is not supportedCOPY TO
: Exporting data from array columns using the COPY TO
command is not availableCREATE INDEX
: Index on a table cannot be created on an array column.