On Thu, Aug 25, 2011 at 5:51 PM, Jim Nasby <j...@nasby.net> wrote: > On Aug 23, 2011, at 1:57 PM, Peter Eisentraut wrote: >>> Ultimately my ulterior motive is to make sure the information schema >>> is actually useful and ensure that it maintains that status. >> >> The information schema only exposes privileges defined in the SQL >> standard on objects defined in the SQL standard. So psql or any tool >> that wants to provide information on PostgreSQL-specific features can't >> use that. But perhaps the JDBC interfaces only expose certain standard >> information anyway, so it could be useful. Depends on the details, >> though. > > Related to this is the newsysviews project, which was intended to present > more human-friendly info ala info_schema, but to also provide > PostgreSQL-specific information (which info_schema can't).
I'll have to have a look at this when I get a moment, sounds promising. Will be even better if we get all clients using it. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
