Postgres Pro
Downloads
Home   >   mailing lists

Re: Convert pg_constraint.conkey array to same-order array of column names - Mailing list pgsql-general

From Dominique Devienne
Subject Re: Convert pg_constraint.conkey array to same-order array of column names
Date
Msg-id CAFCRh-_zr5QFFjxXA5sPN90B9KKb6pjL6jwc2A+NtAH5jqRfaA@mail.gmail.com
Whole thread Raw
In response to Re: Convert pg_constraint.conkey array to same-order array of column names  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Convert pg_constraint.conkey array to same-order array of column names  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
On Fri, Mar 24, 2023 at 5:40 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 3/24/23 03:28, Dominique Devienne wrote:
> On Thu, Mar 23, 2023 at 4:20 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
Your original question was:

"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?"

That is what I showed as a simple example.

Sorry, didn't mean to offend you.

My post started with "preserving order of the columns",
but I probably didn't make it clear enough preserving the source array's order was also a requirement.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Convert pg_constraint.conkey array to same-order array of column names
Next
From: Adrian Klaver
Date:
Subject: Re: Convert pg_constraint.conkey array to same-order array of column names