1. Vertabelo
  2. Fragen
0
Wird überprüft

Support for Postgres array data types

Phil Constantinou vor 6 Jahren • aktualisiert von Mariusz Zakrzewski vor 6 Jahren • 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.

Wird überprüft
Mariusz Zakrzewski vor 6 Jahren

Hi,

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);

Customer support service by UserEcho