George Weaver <gweaver(at)shaw(dot)ca> writes:
> This morning while trying to generate a file of metadata I found that =
> most of the views in Information_Schema are empty, for example =
> referential_constraints, table_constraints, etc.
The information_schema is mostly restricted to show you info about
objects you own --- if you run your test as a superuser, do you get
more info?
(This behavior is per SQL:1999. We recently noticed that SQL:2003 seems
to be laxer and allow you to see info about objects you can access, not
just those you own. We'll probably fix PG 8.2 to follow that behavior,
but it's too late for 8.1.)
regards, tom lane