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 domains
 Schema | Name |  Type   | Modifier 
--------+------+---------+----------
 public | d    | integer | not null
 public | f    | text    | 
(2 rows)

Any thoughts on how to display the check constraints?

-- 
  Rod Taylor


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to