Re: [SPAM] COPY command & binary format

Nicolas Paris <niparisco@xxxxxxxxx> · Tue, 10 May 2016 13:38:12 +0200

2016-05-10 13:04 GMT+02:00 Moreno Andreo <moreno.andreo@xxxxxxxxxx>:

    Il 10/05/2016 12:56, Nicolas Paris ha
      scritto:

        Hello,

        What
          is the way to build a binary format (instead of a csv) ? Is
          there specification for this file ?

          http://www.postgresql.org/docs/9.5/static/sql-copy.html

    I always create binary files with

    COPY table TO 'path/to/file' WITH BINARY

Fine, this works in this way : 
postgresql -> binary
binary -> postgresql

The way I want is :
csv -> binary -> postgresql

And if possible, transforming csv to binary throught java.

Use case is ETL process.