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?