Convert pg_constraint.conkey array to same-order array of column names

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Convert pg_constraint.conkey array to same-order array of column names
Дата
Msg-id CAFCRh-_RY7x0AE0=j-Vu5i5f+FQ=x6ze+4wp1suyAZ=nPQVS1A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Convert pg_constraint.conkey array to same-order array of column names  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Convert pg_constraint.conkey array to same-order array of column names  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-general
Дерево обсуждения
We have a query returning 1 row per constraint column,
which until recently we didn't realize wasn't preserving order of the columns.

A colleague fixed that, with something like below:

SELECT ...
FROM pg_catalog.pg_constraint cnstr
...
CROSS JOIN LATERAL UNNEST(cnstr.conkey) WITH ORDINALITY AS cols(value, rank)
 ORDER BY cols.rank

But I'm wondering about getting 1 row per constraint instead,
and fetching an array of column names.

So is there a way to "convert" int2[] conkey array into a text[] of those column names?

В списке pgsql-general по дате отправления:

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Logical replication fails when adding multiple replicas
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Postgresql professional certification