[EMAIL PROTECTED] (Bruno Wolff III) writes: > Using domains is a good way to keep column constraints in just one place. >
Speaking of domains, how do you find out what the range of a domain is? eg: test=# create domain fruit as text check( value in ('apple', 'orange', 'banana', 'pear')); CREATE DOMAIN test=# \dD fruit List of domains Schema | Name | Type | Modifier --------+-------+------+---------- public | fruit | text | (1 row) test=# \dD+ fuit List of domains Schema | Name | Type | Modifier --------+-------+------+---------- public | fruit | text | (1 row) A quick look through pg_catalog doesn't suggest anything that would return the check conditions - Is there any way to do this? -- Remove -42 for email ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly