Re: information_schema and not-null constraints

On 06.09.23 19:52, Alvaro Herrera wrote:
> +    SELECT current_database()::information_schema.sql_identifier AS constraint_catalog,
> +           rs.nspname::information_schema.sql_identifier AS constraint_schema,
> +           con.conname::information_schema.sql_identifier AS constraint_name,
> +           format('CHECK (%s IS NOT NULL)', at.attname)::information_schema.character_data AS check_clause

Small correction here: This should be

pg_catalog.format('%s IS NOT NULL', at.attname)::information_schema.character_data AS check_clause

That is, the word "CHECK" and the parentheses should not be part of the
produced value.