Re: [SPAM] COPY command & binary format

From: Nicolas Paris <niparisco(at)gmail(dot)com>
To: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: [SPAM] COPY command & binary format
Date: 2016-05-10 11:38:12
Message-ID: CA+ssMOSVC-Yu+yQXeLHL3c0+iz4g1PEtRM49cVvQxyNFN3d4sA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2016-05-10 13:04 GMT+02:00 Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>:

> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pujol Mathieu 2016-05-10 12:39:50 Re: COPY command & binary format
Previous Message Sameer Kumar 2016-05-10 11:08:37 Re: COPY command & binary format