COPY FROM FORMAT CSV FORCE_NULL(*) ?
Hi, there.
copy force null git commit
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=3b5e03dca2afea7a2c12dbc8605175d0568b5555>
didn't attach a discussion link. So I don't know if it's already been
discussed.
Current seem you cannot do
COPY forcetest FROM STDIN WITH (FORMAT csv, FORCE_NULL(*));
can we have FORCE_NULL(*)? Since We already have FORCE_QUOTE(*).
--
I recommend David Deutsch's <<The Beginning of Infinity>>
Jian
On 2022-07-25 Mo 00:18, jian he wrote:
Hi, there.
copy force null git commit
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=3b5e03dca2afea7a2c12dbc8605175d0568b5555>
didn't attach a discussion link. So I don't know if it's already been
discussed.Current seem you cannot do
COPY forcetest FROM STDIN WITH (FORMAT csv, FORCE_NULL(*));can we have FORCE_NULL(*)? Since We already have FORCE_QUOTE(*).
We only started adding discussion links in later years. Here's a link to
the original discussion.
</messages/by-id/CAB8KJ=jS-Um4TGwenS5wLUfJK6K4rNOm_V6GRUj+tcKekL2=GQ@mail.gmail.com>
Offhand I don't see why we shouldn't have this. Someone interested
enough would need to submit a patch.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
Hi,
Agree, FORCE_NULL(*) is useful as well as FORCE_NOT_NULL(*).
We can have them both.
They are useful when users copy tables that have many columns.
Regards,
Zhang Mingli
Show quoted text
On Jul 25, 2022, 21:28 +0800, Andrew Dunstan <andrew@dunslane.net>, wrote:
On 2022-07-25 Mo 00:18, jian he wrote:
Hi, there.
copy force null git commit
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=3b5e03dca2afea7a2c12dbc8605175d0568b5555>
didn't attach a discussion link. So I don't know if it's already been
discussed.Current seem you cannot do
COPY forcetest FROM STDIN WITH (FORMAT csv, FORCE_NULL(*));can we have FORCE_NULL(*)? Since We already have FORCE_QUOTE(*).
We only started adding discussion links in later years. Here's a link to
the original discussion.</messages/by-id/CAB8KJ=jS-Um4TGwenS5wLUfJK6K4rNOm_V6GRUj+tcKekL2=GQ@mail.gmail.com>
Offhand I don't see why we shouldn't have this. Someone interested
enough would need to submit a patch.cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com