1. Vertabelo
  2. Spørgsmål
0
Under vurdering

Support for Postgres array data types

Phil Constantinou 6 år siden • opdateret af Mariusz Zakrzewski 6 år siden • 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.

Under vurdering
Mariusz Zakrzewski 6 år siden

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

Kundesupport af UserEcho