Horton

Thread

Commits

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

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

  1. COPY FROM FORMAT CSV FORCE_NULL(*) ?

    jian he <jian.universality@gmail.com> — 2022-07-25T04:18:12Z

    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

  2. Re: COPY FROM FORMAT CSV FORCE_NULL(*) ?

    Andrew Dunstan <andrew@dunslane.net> — 2022-07-25T13:28:24Z

    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.


<https://www.postgresql.org/message-id/flat/CAB8KJ%3DjS-Um4TGwenS5wLUfJK6K4rNOm_V6GRUj%2BtcKekL2%3DGQ%40mail.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

  3. Re: COPY FROM FORMAT CSV FORCE_NULL(*) ?

    Zhang Mingli <zmlpostgres@gmail.com> — 2022-07-28T14:09:42Z

    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
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.
>
>
> <https://www.postgresql.org/message-id/flat/CAB8KJ%3DjS-Um4TGwenS5wLUfJK6K4rNOm_V6GRUj%2BtcKekL2%3DGQ%40mail.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
>
>
>