pgsql: Add tab completion for CREATE SCHEMA in psql - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Add tab completion for CREATE SCHEMA in psql
Date
Msg-id E1qF2x4-00174K-0D@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add tab completion for CREATE SCHEMA in psql

The following patterns are added for CREATE SCHEMA:
- AUTHORIZATION, without a schema name or after a schema name.
- Possible list of owner roles after AUTHORIZATION.
- CREATE and GRANT within the supported set of commands.
- Correct object types supported in an embedded CREATE SCHEMA command.

While on it, this commit adjusts the completion done after CREATE
UNLOGGED:
- Addition of SEQUENCE.
- Avoid suggesting MATERIALIZED VIEW in CREATE TABLE.

Author: Dagfinn Ilmari Mannsåker
Reviewed-by: Suraj Khamkar, Michael Paquier
Discussion: https://postgr.es/m/8735snihmz.fsf@wibble.ilmari.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c951e9042dd12db80cac4e9a50f198a1eead2036

Modified Files
--------------
src/bin/psql/tab-complete.c | 45 +++++++++++++++++++++++++++++++++++++--------
1 file changed, 37 insertions(+), 8 deletions(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Use named captures in Catalog::ParseHeader()
Next
From: Michael Paquier
Date:
Subject: pgsql: Fix marking of indisvalid for partitioned indexes at creation