git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Allow COPY FROM to filter data using WHERE conditions

author Tomas Vondra <tomas.vondra@postgresql.org>

2019年1月19日 22:48:16 +0000 (23:48 +0100)

committer Tomas Vondra <tomas.vondra@postgresql.org>

2019年1月19日 23:22:14 +0000 (00:22 +0100)

commit 31f3817402da736b29014ace470cf70aeb126ac5

tree ab02bcacacdb944f47996f10435a94c9f0258543 tree

parent d6ef7fe75c1fb7ccc4ad8e3dd38d4e84d6fe9b9f commit | diff

Allow COPY FROM to filter data using WHERE conditions

Extends the COPY FROM command with a WHERE condition, which allows doing
various types of filtering while importing the data (random sampling,
condition on a data column, etc.). Until now such filtering required
either preprocessing of the input data, or importing all data and then
filtering in the database. COPY FROM ... WHERE is an easy-to-use and
low-overhead alternative for most simple cases.

Author: Surafel Temesgen
Reviewed-by: Tomas Vondra, Masahiko Sawada, Lim Myungkyu
Discussion: https://www.postgresql.org/message-id/flat/CALAY4q_DdpWDuB5-Zyi-oTtO2uSk8pmy+dupiRe3AvAc++1imA@mail.gmail.com

13 files changed:

doc/src/sgml/ref/copy.sgml diff | blob | blame | history

src/backend/commands/copy.c diff | blob | blame | history

src/backend/nodes/copyfuncs.c diff | blob | blame | history

src/backend/nodes/equalfuncs.c diff | blob | blame | history

src/backend/parser/gram.y diff | blob | blame | history

src/backend/parser/parse_agg.c diff | blob | blame | history

src/backend/parser/parse_expr.c diff | blob | blame | history

src/backend/parser/parse_func.c diff | blob | blame | history

src/include/nodes/parsenodes.h diff | blob | blame | history

src/include/parser/parse_node.h diff | blob | blame | history

src/interfaces/ecpg/preproc/ecpg.addons diff | blob | blame | history

src/test/regress/expected/copy2.out diff | blob | blame | history

src/test/regress/sql/copy2.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom