Re: [HACKERS] How to display privileges in psql

2004-07-20 Thread Bruce Momjian
Added to TODO: * Allow psql to display permission information using \df+ and \l+ --- Christopher Kings-Lynne wrote: Maybe other people want to comment on this issue. So far, \z and \dp have shown privileges

Re: [HACKERS] How to display privileges in psql

2004-07-20 Thread Peter Eisentraut
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? -- Peter Eisentraut http://developer.postgresql.org/~petere/

Re: [HACKERS] How to display privileges in psql

2004-07-20 Thread David Fetter
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

Re: [HACKERS] How to display privileges in psql

2004-07-20 Thread Bruce Momjian
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? OK, item wording updated. -- Bruce Momjian

[HACKERS] How to display privileges in psql

2004-07-15 Thread Peter Eisentraut
Maybe other people want to comment on this issue. So far, \z and \dp have shown privileges of tables. Now \dn+ and \db+ show the privileges of schemas and tablespaces. Should we, for consistency, move the table privilege display to \dt+, or should we move the schema and tablespace display to,

Re: [HACKERS] How to display privileges in psql

2004-07-15 Thread Bruce Momjian
Peter Eisentraut wrote: Maybe other people want to comment on this issue. So far, \z and \dp have shown privileges of tables. Now \dn+ and \db+ show the privileges of schemas and tablespaces. Should we, for consistency, move the table privilege display to \dt+, or should we move the

Re: [HACKERS] How to display privileges in psql

2004-07-15 Thread Alvaro Herrera
On Thu, Jul 15, 2004 at 10:41:49AM -0400, Bruce Momjian wrote: Peter Eisentraut wrote: Maybe other people want to comment on this issue. So far, \z and \dp have shown privileges of tables. Now \dn+ and \db+ show the privileges of schemas and tablespaces. Should we, for

Re: [HACKERS] How to display privileges in psql

2004-07-15 Thread Bruce Momjian
Alvaro Herrera wrote: On Thu, Jul 15, 2004 at 10:41:49AM -0400, Bruce Momjian wrote: Peter Eisentraut wrote: Maybe other people want to comment on this issue. So far, \z and \dp have shown privileges of tables. Now \dn+ and \db+ show the privileges of schemas and tablespaces.

Re: [HACKERS] How to display privileges in psql

2004-07-15 Thread Dennis Bjorklund
On Thu, 15 Jul 2004, Alvaro Herrera wrote: IMHO the \dn+ output would get too wide if you do that. I'd be in favor of using \zletter to display permissions of the object in \dletter I think it's time to start with longer command names. Tab completion makes it easy anyway. The short ones

Re: [HACKERS] How to display privileges in psql

2004-07-15 Thread Christopher Kings-Lynne
Maybe other people want to comment on this issue. So far, \z and \dp have shown privileges of tables. Now \dn+ and \db+ show the privileges of schemas and tablespaces. Should we, for consistency, move the table privilege display to \dt+, or should we move the schema and tablespace display to, say