Creating a table with an array column : Array Column « Array « PostgreSQL






  1. PostgreSQL
  2. Array
  3. Array Column

Creating a table with an array column


postgres=# -- Creating a table with an array column
postgres=#
postgres=# CREATE TABLE books (employee_id integer, books text[]);
CREATE TABLE
postgres=#
postgres=#
postgres=# drop table books;
DROP TABLE
postgres=#








Related examples in the same category

1.Integer array and text array
2.Two dimentional array
3.Creating a table with a multidimensional array column