On Mon, Mar 01, 2004 at 11:09:32 -0600,
Shawn Harrison <harrison(at)tbc(dot)net> wrote:
>
> Would it be worthwhile to move many of these \d queries into the system
> schema, as views on various system tables? I've thought that it would be
> very useful to be able to access these things through the web or other
> clients. I could see the benefit of providing users with a consistent
> interface
> to such "database metadata", no matter what client one is using. (OTOH, one
> could argue, learning to do that is a pgsql rite-of-passage. ;-> ).
If you are using 7.4.x look at the information_schema schema. This is going
to provide a stable way to get meta data.