On lör, 2011-08-06 at 12:58 +0100, Dean Rasheed wrote: > Right now \d gives: > > Table "public.foo" > Column | Type | Modifiers > --------+---------+----------- > a | integer | not null > b | integer | > c | integer | > Check constraints: > "foo_b_check" CHECK (b IS NOT NULL) > "foo_c_check" CHECK (NOT c IS NULL) > > With this approach, one change would be that you'd gain an extra "not > null" in the Modifiers column for "b". > > But how many CHECK constraints would show? I guess it would show 3, > although it could be changed to just show 1. But it certainly couldn't > continue to show 2, since nothing in the catalogs could distinguish > the constraints on "a" from those on "b".
I'd say we would show all (what is currently known as) NOT NULL constraints under "Check constraints:". -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers