SQL ARRAY: Difference between revisions
Jump to navigation
Jump to search
(→Insert) |
|||
| Line 15: | Line 15: | ||
=Insert= | =Insert= | ||
<syntaxhighlight lang='sql'> | |||
INSERT INTO some_table (some_column, ...) VALUES (ARRAY['string1', 'string2', ...], ...) | |||
</syntaxhighlight> | |||
Revision as of 22:54, 24 May 2024
Internal
Overview
Declaration
SQL declaration for unidimensional arrays:
CREATE TABLE some_table (
some_column text ARRAY
...
)
ARRAY can be declared for any data types.
Insert
INSERT INTO some_table (some_column, ...) VALUES (ARRAY['string1', 'string2', ...], ...)