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 \zn and \zb?  Or 
maybe this is not an issue at all.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

Thu, 15 Jul 2004 14:11:35 +0200
Peter Eisentraut <peter_e@gmx.net>
How to display privileges in psql
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 schema and tablespace display to, say \zn and \zb?  Or 
> maybe this is not an issue at all.

Now that you mention it, it does seem nice to show permissions in \dt+.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Thu, 15 Jul 2004 10:41:49 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: How to display privileges in psql
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 consistency, move the table privilege display to \dt+, or 
> > should we move the schema and tablespace display to, say \zn and \zb?  Or 
> > maybe this is not an issue at all.
> 
> Now that you mention it, it does seem nice to show permissions in \dt+.

IMHO the \dn+ output would get too wide if you do that.  I'd be in favor
of using \z<letter> to display permissions of the object in \d<letter>

Something that annoys me is that the \? shows

\dt		description of what it does ...
		add + for more details

where it should be

\dt[+]		same description

No need to say what the + does, it should be obvious.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Para tener mï¿½s hay que desear menos"


Thu, 15 Jul 2004 13:22:42 -0400
Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: How to display privileges in psql
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.
> > > 
> > > Should we, for consistency, move the table privilege display to \dt+, or 
> > > should we move the schema and tablespace display to, say \zn and \zb?  Or 
> > > maybe this is not an issue at all.
> > 
> > Now that you mention it, it does seem nice to show permissions in \dt+.
> 
> IMHO the \dn+ output would get too wide if you do that.  I'd be in favor
> of using \z<letter> to display permissions of the object in \d<letter>

Is the new \db+ and \dn+ too wide now?

Actually it looks like \db+ is fine but \dn+ is long because it has both
permissions and a description:
	
	test=> \dt+
	               List of relations
	 Schema | Name | Type  |  Owner   | Description
	--------+------+-------+----------+-------------
	 public | test | table | postgres |
	(1 row)
	
	test=> \db+
	                 List of tablespaces
	    Name    |  Owner   | Location | Access privileges
	------------+----------+----------+-------------------
	 pg_default | postgres |          |
	 pg_global  | postgres |          |
	(2 rows)
	
	test=> \dn+
	                                            List of schemas
	        Name        |  Owner   |          Access privileges          |           Description
	--------------------+----------+-------------------------------------+----------------------------------
	 information_schema | postgres | {postgres=UC/postgres,=U/postgres}  |
	 pg_catalog         | postgres | {postgres=UC/postgres,=U/postgres}  | System catalog schema
	 pg_toast           | postgres |                                     | Reserved schema for TOAST tables
	 public             | postgres | {postgres=UC/postgres,=UC/postgres} | Standard public schema
	(4 rows)

> Something that annoys me is that the \? shows
> 
> \dt		description of what it does ...
> 		add + for more details
> 
> where it should be
> 
> \dt[+]		same description
> 
> No need to say what the + does, it should be obvious.

Good idea.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Thu, 15 Jul 2004 14:56:13 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: How to display privileges in psql
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<letter> to display permissions of the object in \d<letter>

I think it's time to start with longer command names. Tab completion makes 
it easy anyway. The short ones should still be there, but not every 
command needs a short form.

-- 
/Dennis Bjï¿½rklund


Thu, 15 Jul 2004 21:37:41 +0200 (CEST)
Dennis Bjorklund <db@zigo.dhs.org>
Re: How to display privileges in psql
> 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 \zn and \zb?  Or 
> maybe this is not an issue at all.

I don't know :(

psql is starting to struggle to show all information!

And what about \df+ and \l+ ?  They both need privilege display as well.

Chris


Fri, 16 Jul 2004 12:26:07 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: How to display privileges in psql

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 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 \zn and \zb?  Or 
> > maybe this is not an issue at all.
> 
> I don't know :(
> 
> psql is starting to struggle to show all information!
> 
> And what about \df+ and \l+ ?  They both need privilege display as well.
> 
> Chris
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Tue, 20 Jul 2004 17:01:31 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: How to display privileges in psql
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/


Tue, 20 Jul 2004 23:41:14 +0200
Peter Eisentraut <peter_e@gmx.net>
Re: How to display privileges in psql
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@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

Tue, 20 Jul 2004 14:53:44 -0700
David Fetter <david@fetter.org>
Re: How to display privileges in psql
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                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Tue, 20 Jul 2004 18:30:23 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: How to display privileges in psql