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

git projects / postgresql.git / commit

Add a DEFAULT option to COPY FROM

author Andrew Dunstan <andrew@dunslane.net>

2023年3月13日 14:01:56 +0000 (10:01 -0400)

committer Andrew Dunstan <andrew@dunslane.net>

2023年3月13日 14:01:56 +0000 (10:01 -0400)

commit 9f8377f7a27910bf0f35bf5169a8046731948a79

tree e0a19449e4cebb8923dfcd1bba95a1d3363faa32 tree

parent 7b14e20b12cc8358cad9bdd05dd6b7de7f73c431 commit | diff

Add a DEFAULT option to COPY FROM

This allows for a string which if an input field matches causes the
column's default value to be inserted. The advantage of this is that
the default can be inserted in some rows and not others, for which
non-default data is available.

The file_fdw extension is also modified to take allow use of this
option.

Israel Barth Rubio

Discussion: https://postgr.es/m/CAO_rXXAcqesk6DsvioOZ5zmeEmpUN5ktZf-9=9yu+DTr0Xr8Uw@mail.gmail.com

15 files changed:

contrib/file_fdw/data/copy_default.csv [new file with mode: 0644] blob

contrib/file_fdw/expected/file_fdw.out diff | blob | blame | history

contrib/file_fdw/file_fdw.c diff | blob | blame | history

contrib/file_fdw/sql/file_fdw.sql diff | blob | blame | history

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

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

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

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

src/bin/psql/t/001_basic.pl diff | blob | blame | history

src/bin/psql/t/010_tab_completion.pl diff | blob | blame | history

src/bin/psql/tab-complete.c diff | blob | blame | history

src/include/commands/copy.h diff | blob | blame | history

src/include/commands/copyfrom_internal.h 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