Stephen Frost <[EMAIL PROTECTED]> writes: > You might want to take a look at the schema called 'information_schema' > and see if you can find what you want there. The only problem I have > with that, currently anyway, is that it seems to only show things the > current user owns as opposted to what the current user has access to, > which seems a bit silly to me.
The SQL99 spec defines some of the views as showing only what you own, and others as showing whatever you have access to. I think we track the spec, but feel free to point out discrepancies. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq