En revisión

Support for Postgres array data types

Phil Constantinou hace 3 años actualizado por Mariusz Zakrzewski hace 3 años 1

How should I handle array data types from Postgres 9.2 in Vertabelo. 

- Can I declare them visually?

- Can I create indexes on them?

- If not, is there a workaround.

En revisión


Simply input the desired data type in form - e.g. 'integer[]'. Yes, you can create an index on them - the same as on any other column. 

Resulting DDL is:

CREATE TABLE sample_table (
   id int  NOT NULL,
   sample_column integer[]  NOT NULL,
   CONSTRAINT sample_table_pk PRIMARY KEY (id)
CREATE INDEX sample_table_idx_1 on sample_table (sample_column ASC);