IntermediateBasic SELECT

Array data types

The query

SQL

CREATE TABLE blog_posts (
  id SERIAL PRIMARY KEY,
  title TEXT,
  tags TEXT[]
);

INSERT INTO blog_posts (title, tags) 
VALUES ('PostgreSQL Tips', ARRAY['sql', 'database', 'pg']);

Tested against PostgreSQL 16

Note

“PostgreSQL supports native arrays. You can use ARRAY[...] or curly braces \'{sql, db}\' as string literals.