Write insert query with udt array which contains udt array

Question

I am trying to create the next table structure:

create type my_type1 as (val_s text);
create type my_type2 as (val_s text, val_t my_type1[]);
create table my_table(val_t my_type2[]);

And I want to write an insert query like this: insert into my_table (val_t) values ('{ "text", ''{"text1","text2"}'' }');

Please, help. I am using PostgreSQL 12

insert into my_table (val_t) values ('{ "text", ''{"text1","text2"}'' }');

Are you getting any error when executing your DDL and INSERT query ? — DataWrangler
– DataWrangler, Commented Apr 28, 2023 at 13:16
Yes, I can not run insert query. It is my main question. I found this solution stackoverflow.com/a/66384769/19593931 . But I want to insert without ARRAY and ROW keywords — Ilya Mushchenko
– Ilya Mushchenko, Commented Apr 28, 2023 at 13:30
The insert statement is repeated. It irritates me this way. — greybeard
– greybeard, Commented May 1, 2023 at 15:07

DataWrangler · Accepted Answer · 2023-04-28 13:33:14Z

0

If your intention is to just have the data inserted as it is you can use the TEXT datatype

Schema (PostgreSQL v12)

CREATE TABLE my_table (
    val_t         text
);

insert into my_table (val_t) values ('{ "text", ''{"text1","text2"}'' }');

Query #1

SELECT * FROM my_table;

val_t
{ "text", '{"text1","text2"}' }

answered Apr 28, 2023 at 13:33

DataWrangler

2,20520 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sorry, but I need UDTs