Re: [PATCHES] psql: \dg and groups for \du
Peter Eisentraut wrote: > Note that it is planned to unify users and groups into a general "role" > entity, so this command is probably going to go away soon. NP, at least the code is there for reuse. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [PATCHES] psql: \dg and groups for \du
Note that it is planned to unify users and groups into a general "role" entity, so this command is probably going to go away soon. Bruce Momjian writes: > Nice: > > test=> create group test; > CREATE GROUP > test=> \dg > List of database groups >Group name | Group ID > +-- >test | 100 > (1 row) > > test=> alter group test add user postgres; > ALTER GROUP > test=> \du > List of database users >User name | User ID | Attributes | Groups > ---+-++ >postgres | 1 | superuser, create database | {test} > (1 row) > > Patch applied, docs added, TODO updated. Thanks. > > --- > > Markus Bertheau wrote: > > Hi, > > > > attached is a patch that adds display of the groups a user belongs to to > > \du and a \dg command to psql. It's against 7.4beta5. > > > > -- > > Markus Bertheau <[EMAIL PROTECTED]> > > [ Attachment, skipping... ] > > > > > ---(end of broadcast)--- > > TIP 6: Have you searched our list archives? > > > >http://archives.postgresql.org > > -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [PATCHES] psql: \dg and groups for \du
Nice: test=> create group test; CREATE GROUP test=> \dg List of database groups Group name | Group ID +-- test | 100 (1 row) test=> alter group test add user postgres; ALTER GROUP test=> \du List of database users User name | User ID | Attributes | Groups ---+-++ postgres | 1 | superuser, create database | {test} (1 row) Patch applied, docs added, TODO updated. Thanks. --- Markus Bertheau wrote: > Hi, > > attached is a patch that adds display of the groups a user belongs to to > \du and a \dg command to psql. It's against 7.4beta5. > > -- > Markus Bertheau <[EMAIL PROTECTED]> [ Attachment, skipping... ] > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] psql: \dg and groups for \du
I will write the psql.sgml changes. Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Markus Bertheau wrote: > Hi, > > attached is a patch that adds display of the groups a user belongs to to > \du and a \dg command to psql. It's against 7.4beta5. > > -- > Markus Bertheau <[EMAIL PROTECTED]> [ Attachment, skipping... ] > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html