Re: Two questions about "pg_constraint"

> adrian(dot)klaver(at)aklaver(dot)com wrote:
>
>> bryn(at)yugabyte(dot)com wrote:
>>
>> Question 2: what happened to the column "consrc"?
>
> It was in 11 but not later, so let's look at release notes...

HERE:
https://www.postgresql.org/docs/12/release-12.html

> «
> Remove obsolete pg_constraint.consrc column (Peter Eisentraut)
>
> This column has been deprecated for a long time, because it did not update in response to other catalog changes (such as column renamings). The recommended way to get a text version of a check constraint's expression from pg_constraint is pg_get_expr(conbin, conrelid). pg_get_constraintdef() is also a useful alternative.
> »

Thanks, Adrian. I should have tried Google for "remove pg_constraint consrc". This finds the quote as the top hit.

I confirmed that "pg_get_expr(conbin, conrelid)" shows « (v = lower(v)) » for my example table.