psql: Improve tab completion for GRANT/REVOKE
authorMichael Paquier <michael@paquier.xyz>
Fri, 18 Nov 2022 02:26:49 +0000 (11:26 +0900)
committerMichael Paquier <michael@paquier.xyz>
Fri, 18 Nov 2022 02:26:49 +0000 (11:26 +0900)
commit07f7237c2a3bcc2eebb554f812378188b07571bb
treed947968a48f48431aadf3bbfec04041eaabd6b20
parent967db242c2aa7d50300e20bd8a403bd905feec38
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
src/bin/psql/tab-complete.c