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

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? Ex

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 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 privi

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

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 \z to display permissions of the object in \d I think it's time to start with longer command names. Tab completion makes it easy anyway. The short ones should still be

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 a

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,

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

[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, s