Re: Why doesn't psql use the information schema to get ACL description ?

On Thu, Aug 25, 2011 at 5:51 PM, Jim Nasby <jim(at)nasby(dot)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