Re: [PATCHES] psql schema permissions

2004-07-13 Thread Bruce Momjian
Dennis Bjorklund wrote: There is no way to show schema permissions in psql. The alternatives are: 1) A new \dpn command 2) Extend \dp to also show rights for schemas, but then we need an extra column to describe what kind of object it is, and it would mess up the pattern

Re: [PATCHES] psql schema permissions

2004-07-02 Thread Peter Eisentraut
Am Mittwoch, 30. Juni 2004 15:18 schrieb Dennis Bjorklund: There is no way to show schema permissions in psql. You could extend \z (don't know where that name came from) so that \zX show the permissions for things that \dX displays. ---(end of

Re: [PATCHES] psql schema permissions

2004-07-02 Thread Dennis Bjorklund
On Fri, 2 Jul 2004, Peter Eisentraut wrote: You could extend \z (don't know where that name came from) so that \zX show the permissions for things that \dX displays. Yes, that was number 1) on the list 1) A new \dpn command \dp and \z is the same thing. Any solution works for me. The

[PATCHES] psql schema permissions

2004-06-30 Thread Dennis Bjorklund
There is no way to show schema permissions in psql. The alternatives are: 1) A new \dpn command 2) Extend \dp to also show rights for schemas, but then we need an extra column to describe what kind of object it is, and it would mess up the pattern stuff. 3) Do nothing and let

Re: [PATCHES] psql schema permissions

2004-06-30 Thread Kris Jurka
On Wed, 30 Jun 2004, Dennis Bjorklund wrote: There is no way to show schema permissions in psql. 4) Since \dn only shows the name and the owner we can simply add a permission column. Someone requested that \dn+ also show the comment for the schema, if you're messing around in

Re: [PATCHES] psql schema permissions

2004-06-30 Thread Dennis Bjorklund
On Wed, 30 Jun 2004, Kris Jurka wrote: There is no way to show schema permissions in psql. 4) Since \dn only shows the name and the owner we can simply add a permission column. Someone requested that \dn+ also show the comment for the schema, if you're messing around in that