On Mon, Mar 01, 2004 at 11:09:32 -0600, Shawn Harrison <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster