Postgres Pro
Downloads
Home   >   mailing lists

Re: [SPAM] COPY command & binary format - Mailing list pgsql-general

From Nicolas Paris
Subject Re: [SPAM] COPY command & binary format
Date
Msg-id CA+ssMOSVC-Yu+yQXeLHL3c0+iz4g1PEtRM49cVvQxyNFN3d4sA@mail.gmail.com
Whole thread Raw
In response to Re: [SPAM] COPY command & binary format  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Responses Re: [SPAM] COPY command & binary format  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Re: [SPAM] COPY command & binary format  (Cat <cat@zip.com.au>)
List pgsql-general
Tree view
2016-05-10 13:04 GMT+02:00 Moreno Andreo <moreno.andreo@evolu-s.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.

pgsql-general by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: COPY command & binary format
Next
From: Pujol Mathieu
Date:
Subject: Re: COPY command & binary format