Horton

COPY FROM FORMAT CSV FORCE_NULL(*) ?

jian he <jian.universality@gmail.com>

View thread View on postgr.es
From: jian he <jian.universality@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-07-25T04:18:12Z
Lists: pgsql-hackers 
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

Commits

  1. Provide FORCE_NULL * and FORCE_NOT_NULL * options for COPY FROM

  2. Provide a FORCE NULL option to COPY in CSV mode.