Working With Arrays
PostgreSQL supports flexible array types. These arrays are also supported in the Supabase Dashboard and in the JavaScript API.
Create a table with an array column
Create a test table with a text array (an array of strings):
- Go to the Table editor page in the Dashboard.
- Click New Table and create a table with the name
arraytest
. - Click Save.
- Click New Column and create a column with the name
textarray
, typetext
, and select Define as array. - Click Save.
Insert a record with an array value
- Go to the Table editor page in the Dashboard.
- Select the
arraytest
table. - Click Insert row and add
["Harry", "Larry", "Moe"]
. - Click Save.
View the results
- Go to the Table editor page in the Dashboard.
- Select the
arraytest
table.
You should see:
_10| id | textarray |_10| --- | ----------------------- |_10| 1 | ["Harry","Larry","Moe"] |
Query array data
PostgreSQL uses 1-based indexing (e.g., textarray[1]
is the first item in the array).
To select the first item from the array and get the total length of the array:
_10SELECT textarray[1], array_length(textarray, 1) FROM arraytest;
returns:
_10| textarray | array_length |_10| --------- | ------------ |_10| Harry | 3 |