ARRAY

ARRAY is a SQL data type in the PostgreSQL Specific category. PostgreSQL supports array columns and array operations. Can be multi-dimensional. The syntax is column TEXT[] / INTEGER[] / ARRAY[value1, value2]. It returns array. A typical example: CREATE TABLE students ( name TEXT, grades INTEGER[] ); INSERT INTO students VALUES ('Alice', '{85, 92, 78}'); SELECT name, grades[1] FROM students; -- First grade: 85 SELECT * FROM students WHERE 92 = ANY(grades); A close relative is SERIAL, which postgreSQL auto-increment type. Creates an INTEGER column with a sequence. Equivalent to AUTO_INCREMENT in MySQL. A close relative is RETURNING, which postgreSQL extension that returns values from INSERT/UPDATE/DELETE statements (like OUTPUT in SQL Server). A close relative is JSONB, which postgreSQL binary JSON type, more efficient than plain JSON. Supports indexing (GIN) and path queries. More about this category: PostgreSQL-specific features — SERIAL, RETURNING, ARRAY, JSONB, UPSERT. Related PostgreSQL Specific entries: SERIAL, RETURNING, JSONB, UPSERT (INSERT ON CONFLICT), ILIKE, BIGSERIAL / SMALLSERIAL, GENERATED AS IDENTITY, COPY.