Horton

psql: Improve tab completion for GRANT/REVOKE

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: 07f7237c2a3bcc2eebb554f812378188b07571bb
Author: Michael Paquier <michael@paquier.xyz>
Date: 2022-11-18T02:26:49Z
Releases: 16.0 
psql: Improve tab completion for GRANT/REVOKE

This commit improves the handling of the following clauses:
- Addition of "CREATE" for ALTER DEFAULT PRIVILEGES .. GRANT/REVOKE.
- Addition of GRANT|ADMIN|INHERIT OPTION FOR for REVOKE, with some
completion for roles, INHERIT being added recently by e3ce2de.
- Addition of GRANT WITH ADMIN|INHERIT.

The list of privilege options common to GRANT and REVOKE is refactored
to avoid its duplication.

Author: Shi Yu
Reviewed-by: Kyotaro Horiguchi, Michael Paquier, Peter Smith
Discussion: https://postgr.es/m/OSZPR01MB6310FCE8609185A56344EED2FD559@OSZPR01MB6310.jpnprd01.prod.outlook.com

Files

PathChange+/−
src/bin/psql/tab-complete.c modified +27 −26

Discussion