pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: psql: Improve tab completion for COPY command. 3+ messages / 2 participants [nested] [flat]
* pgsql: psql: Improve tab completion for COPY command. @ 2025-06-30 09:36 Fujii Masao <fujii@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Fujii Masao @ 2025-06-30 09:36 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org psql: Improve tab completion for COPY command. Previously, tab completion for COPY only suggested plain tables and partitioned tables, even though materialized views are also valid for COPY TO (since commit 534874fac0b), and foreign tables are valid for COPY FROM. This commit enhances tab completion for COPY to also include materialized views and foreign tables. Views with INSTEAD OF INSERT triggers are supported with COPY FROM but rarely used, so plain views are intentionally excluded from completion. Author: jian he <jian.universality@gmail.com> Co-authored-by: Fujii Masao <masao.fujii@gmail.com> Reviewed-by: Kirill Reshke <reshkekirill@gmail.com> Reviewed-by: David G. Johnston <david.g.johnston@gmail.com> Discussion: https://postgr.es/m/CACJufxFxnSkikp+GormAGHcMTX1YH2HRXW1+3dJM9w7yY9hdsg@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/a4c10de9291291bce3dd2b81bd8b5f0b98649244 Modified Files -------------- src/bin/psql/tab-complete.in.c | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: psql: Improve tab completion for COPY ... STDIN/STDOUT. @ 2025-11-04 18:41 Masahiko Sawada <msawada@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Masahiko Sawada @ 2025-11-04 18:41 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org psql: Improve tab completion for COPY ... STDIN/STDOUT. This commit enhances tab completion for both COPY FROM and COPY TO commands to suggest STDIN and STDOUT, respectively. To make suggesting both file names and keywords easier, it introduces a new COMPLETE_WITH_FILES_PLUS() macro. Author: Yugo Nagata <nagata@sraoss.co.jp> Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com> Discussion: https://postgr.es/m/20250605100835.b396f9d656df1018f65a4556@sraoss.co.jp Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/02fd47dbfade9b86ae4c34b5b01e10abb6dc45dc Modified Files -------------- src/bin/psql/tab-complete.in.c | 84 ++++++++++++++++++++++++++++++++++++++---- 1 file changed, 77 insertions(+), 7 deletions(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: psql: Improve tab completion for COPY option lists. @ 2025-12-22 22:29 Masahiko Sawada <msawada@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Masahiko Sawada @ 2025-12-22 22:29 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org psql: Improve tab completion for COPY option lists. Previously, only the first option in a parenthesized option list was suggested by tab completion. This commit enhances tab completion for both COPY TO and COPY FROM commands to suggest options after each comma. Also add completion for HEADER and FREEZE option value candidates. Author: Yugo Nagata <nagata@sraoss.co.jp> Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com> Discussion: https://postgr.es/m/20250605100835.b396f9d656df1018f65a4556@sraoss.co.jp Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/c6a7d3bab493e8d589f24d239db00ce5c2934178 Modified Files -------------- src/bin/psql/tab-complete.in.c | 68 +++++++++++++++++++++++++++--------------- 1 file changed, 44 insertions(+), 24 deletions(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-12-22 22:29 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-06-30 09:36 pgsql: psql: Improve tab completion for COPY command. Fujii Masao <fujii@postgresql.org> 2025-11-04 18:41 pgsql: psql: Improve tab completion for COPY ... STDIN/STDOUT. Masahiko Sawada <msawada@postgresql.org> 2025-12-22 22:29 pgsql: psql: Improve tab completion for COPY option lists. Masahiko Sawada <msawada@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox