Re: Add support for DEFAULT specification in COPY FROM
Israel Barth Rubio <barthisrael@gmail.com>
From: Israel Barth Rubio <barthisrael@gmail.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2022-09-26T15:12:15Z
Lists: pgsql-hackers
Attachments
- v3-0001-Added-support-for-DEFAULT-in-COPY-FROM.patch (application/octet-stream) patch v3-0001
Hello Andrew, > . There needs to be a check that this is being used with COPY FROM, and > the restriction needs to be stated in the docs and tested for. c.f. > FORCE NULL. > > . There needs to be support for this in psql's tab_complete.c, and > appropriate tests added > > . There needs to be support for it in contrib/file_fdw/file_fdw.c, and a > test added > > . The tests should include psql's \copy as well as sql COPY > > . I'm not sure we need a separate regression test file for this. > Probably these tests can go at the end of src/test/regress/sql/copy2.sql. Thanks for your review! I have applied the suggested changes, and I'm submitting the new patch version. Kind regards, Israel.
Commits
-
Add a DEFAULT option to COPY FROM
- 9f8377f7a279 16.0 landed