Re: How to display privileges in psql

From: David Fetter <david(at)fetter(dot)org>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to display privileges in psql
Date: 2004-07-20 21:53:44
Message-ID: 20040720215344.GY15150@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jul 20, 2004 at 11:41:14PM +0200, Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > Added to TODO:
> >
> > * Allow psql to display permission information using \df+ and
> > \l+
>
> What about, develop a consistent way to display privilege
> information for all objects in psql?

Excellent idea. :)

Is this worth breaking backward compatibility for? IMHO, yes, but
others may have good reasons--critical-path psql scripts, e.g.--for
not doing it.

BTW, while I working out an example for CREATE DOMAIN
(http://fetter.org/sgml/sql-createdomain.html), I found that \dD and
\dD+ appear to do the exact same thing. I was hoping that \dD+ would
show all CONSTRAINTs.

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2004-07-20 22:09:29 Re: [HACKERS] Point in Time Recovery
Previous Message Peter Eisentraut 2004-07-20 21:41:14 Re: How to display privileges in psql