psql tab auto-complete for CREATE PUBLICATION
Peter Smith <smithpb2250@gmail.com>
From: Peter Smith <smithpb2250@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-07-09T07:36:04Z
Lists: pgsql-hackers
Attachments
- v1-0001-more-auto-complete-for-CREATE-PUBLICATION.patch (application/octet-stream) patch v1-0001
I found that the psql tab auto-complete was not working for some cases
of CREATE PUBLICATION [1].
CREATE PUBLICATION name
[ FOR TABLE [ ONLY ] table_name [ * ] [, ...]
| FOR ALL TABLES ]
[ WITH ( publication_parameter [= value] [, ... ] ) ]
~~~
For example, the following scenarios did not work as I was expecting:
"create publication mypub for all tables " TAB --> expected complete
with "WITH ("
"create publication mypub for all ta" TAB --> expected complete with "TABLES"
"create publication mypub for all tables w" TAB --> expected complete
with "WITH ("
"create publication mypub for table mytable " TAB --> expected
complete with "WITH ("
~~~
PSA a small patch which seems to improve at least for those
aforementioned cases.
Now results are:
"create publication mypub for all tables " TAB --> "create publication
mypub for all tables WITH ( "
"create publication mypub for all ta" TAB --> "create publication
mypub for all tables "
"create publication mypub for all tables w" TAB --> "create
publication mypub for all tables with ( "
"create publication mypub for table mytable " TAB --> "create
publication mypub for table mytable WITH ( "
------
[1] https://www.postgresql.org/docs/devel/sql-createpublication.html
Kind Regards,
Peter Smith
Fujitsu Australia
Commits
-
Improve tab-completion for CREATE PUBLICATION.
- b0c066297bda 15.0 landed