Arrays
column_name DATATYPE[] {CONSTRAINT}
CREATE TABLE table_array
(
id SERIAL,
name varchar(100),
grades text[]
);
INSERT INTO table_array (name, grades)
VALUES ('person 1', array ['100','45']);
INSERT INTO table_array (name, grades)
VALUES ('person 2', array ['100','90']);
INSERT INTO table_array (name, grades)
VALUES ('person 3', array ['100','97']);
INSERT INTO table_array (name, grades)
VALUES ('person 4', array ['100','94']);
SELECT name, grades[1]
FROM table_array;
name | grades
----------+--------
person 1 | 100
person 2 | 100
person 3 | 100
person 4 | 100
- for non text data , use
{value1,value2}
orarray ['value1','value2']
- for text data , use
{"value1","value2"}
orarray [value1,value2]
CREATE TABLE teachers
(
id serial primary key,
class text[]
);
CREATE TABLE IF NOT EXISTS teachers
(
id serial primary key,
class text array
);
INSERT INTO teachers (class)
VALUES (array ['english','maths']);
id | class
----+-----------------
1 | {english,maths}
SELECT class[1]
FROM teachers;