| From: | Jim Nasby <jim(at)nasby(dot)net> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Dave Cramer <pg(at)fastcrypt(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Why doesn't psql use the information schema to get ACL description ? |
| Date: | 2011-08-25 21:51:55 |
| Message-ID: | EA5995BB-1F2A-4206-9A69-88F7FF3059DE@nasby.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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).
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2011-08-25 22:05:35 | Re: pg_restore --no-post-data and --post-data-only |
| Previous Message | Jim Nasby | 2011-08-25 21:45:15 | Re: Buffering GiST leaf pages too |