Thread: Domain Constraints

Any thoughts on how to display the domain constraints in psql?


a=# create domain d as integer not null check (value > 4);
CREATE DOMAIN
a=# create domain f as text check (value > 'bob') check (value < 'zip');
CREATE DOMAIN
a=# \dD         List of domainsSchema | Name |  Type   | Modifier 
--------+------+---------+----------public | d    | integer | not nullpublic | f    | text    | 
(2 rows)

Any thoughts on how to display the check constraints?

--  Rod Taylor