How to insert data in object type column in Postgresql table

610 Views Asked by At
CREATE TYPE dbobj_vry AS
(
    a character varying[]
);

CREATE TABLE IF NOT EXISTS calender
(
    day_name text COLLATE pg_catalog."default",
    day_date dbobj_vry
)

TABLESPACE pg_default;

Try to insert data in Calendar table.

insert into calender values ('1',dbobj_vry [9,5]);

It is not working.

Error shown - ERROR: syntax error at or near "," LINE 2: dbobj_vry [9,5] ^ SQL state: 42601 Character: 89

0

There are 0 best solutions below