Postgres Pro
Downloads
Home   >   mailing lists

Re: Make COPY format extendable: Extract COPY TO format implementations - Mailing list pgsql-hackers

From Daniel Verite
Subject Re: Make COPY format extendable: Extract COPY TO format implementations
Date
Msg-id ee94f987-f4ca-4a0c-96d7-909465d20808@manitou-mail.org
Whole thread Raw
In response to Make COPY format extendable: Extract COPY TO format implementations  (Sutou Kouhei <kou@clear-code.com>)
Responses Re: Make COPY format extendable: Extract COPY TO format implementations
List pgsql-hackers
Tree view 
    Sutou Kouhei wrote:

> * 2022-04: Apache Arrow [2]
> * 2018-02: Apache Avro, Apache Parquet and Apache ORC [3]
>
> (FYI: I want to add support for Apache Arrow.)
>
> There were discussions how to add support for more formats. [3][4]
> In these discussions, we got a consensus about making COPY
> format extendable.


These formats seem all column-oriented whereas COPY is row-oriented
at the protocol level [1].
With regard to the procotol, how would it work to support these formats?


[1] https://www.postgresql.org/docs/current/protocol-flow.html#PROTOCOL-COPY


Best regards,
--
Daniel Vérité
https://postgresql.verite.pro/
Twitter: @DanielVerite

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Is WAL_DEBUG related code still relevant today?
Next
From: Andrew Dunstan
Date:
Subject: Re: Emitting JSON to file using COPY TO