Re: COPY FROM FORMAT CSV FORCE_NULL(*) ?

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: COPY FROM FORMAT CSV FORCE_NULL(*) ?
Дата
Msg-id bde19f49-8cae-fcdb-cdef-5a3d32355723@dunslane.net
обсуждение исходный текст
Ответ на COPY FROM FORMAT CSV FORCE_NULL(*) ?  (jian he <jian.universality@gmail.com>)
Ответы Re: COPY FROM FORMAT CSV FORCE_NULL(*) ?  (Zhang Mingli <zmlpostgres@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: add log messages when replication slots become active and inactive (was Re: Is it worth adding ReplicationSlot active_pid to ReplicationSlotPersistentData?)
Следующее
От: Pierre
Дата:
Сообщение: Re: log_line_prefix: make it possible to add the search_path