П
Тогда возникает вопрос, почему человек который сам смог описать сущности со связями не может написать, как я понял, любой запрос?
Size: a a a
П
ch
AM
AM
П
Ð
RL
AM
П
YS
EB
МШ
VY
GG
psql> \d+ tst_main
Partitioned table "public.tst_main"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
--------------+-----------------------------+-----------+----------+---------+----------+--------------+-------------
id | integer | | not null | | plain | |
message | text | | | | extended | |
created_date | timestamp without time zone | | not null | | plain | |
Partition key: RANGE (created_date)
Indexes:
"tst_main_pkey" PRIMARY KEY, btree (id, created_date)
Partitions: tst_part_012021 FOR VALUES FROM ('2021-01-01 00:00:00') TO ('2021-02-01 00:00:00'),
tst_part_022021 FOR VALUES FROM ('2021-02-01 00:00:00') TO ('2021-03-01 00:00:00'),
tst_part_032021 FOR VALUES FROM ('2021-03-01 00:00:00') TO ('2021-04-01 00:00:00')
psql> \d+ tst_main2
Partitioned table "public.tst_main2"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
----------------+-----------------------------+-----------+----------+---------+----------+--------------+-------------
id | integer | | not null | | plain | |
message | text | | | | extended | |
external_id | integer | | | | plain | |
completed_date | timestamp without time zone | | not null | | plain | |
Partition key: RANGE (completed_date)
Indexes:
"tst_main2_pkey" PRIMARY KEY, btree (id, completed_date)
Number of partitions: 0
GG
S)

Д

S)
S)
Д
