Re: [PATCH] psql: add \dcs to list all constraints - Mailing list pgsql-hackers

Hi Álvaro and all,

> The next patch will include the following two fixes:
>   - Display all constraint types in full and in lowercase.
>   - Add test cases for temporal constraints.

The above two issues have been addressed in the V7 patch.
Below is an example output.

                             List of constraints
 Schema |      Table      |    Type     |                Name
--------+-----------------+-------------+------------------------------------
 public | temporal_con_fk | foreign key | temporal_con_fk_p_id_valid_at_fkey
 public | temporal_con_pk | not-null    | temporal_con_pk_id_not_null
 public | temporal_con_pk | not-null    | temporal_con_pk_valid_at_not_null
 public | temporal_con_pk | primary key | temporal_con_pk_pkey
 public | temporal_con_uq | unique      | temporal_con_uq_id_valid_at_key
(5 rows)

Please find the attached file.

Regards,
Tatsuro Yamada