On Fri, Apr 01, 2005 at 09:27:40AM -0700, Edmund Bacon wrote: > > Speaking of domains, how do you find out what the range of a domain > is?
I'm not sure if there's a better way, but this appears to work: SELECT pg_get_constraintdef(oid, TRUE) FROM pg_constraint WHERE contypid = 'fruit'::regtype; -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(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
