Is it possible to add array data type to the postgreSQL database?
Like this :
ALTER TABLE table_name
ADD COLUMN new_column_name ARRAY;
Add a comment
|
2 Answers
You will need to define the type of the array, e.g. if you want an array of integers, use int[]
ALTER TABLE table_name
ADD COLUMN new_column_name int[];
(or use the ARRAY keyword as shown in Sebastian's answer)
For more details, see the manual
Comments
You can use ARRAY on any built-in or user-defined base type, enum type, or composite type like this:
ALTER TABLE table_name ADD COLUMN new_column_name INTEGER ARRAY;
