Re: [SPAM] [GENERAL] COPY command & binary format

2016-05-14 Thread Nicolas Paris
Well the job is done. The talend component is working ( https://github.com/parisni/talend/tree/master/tPostgresqlOutputBulkAPHP). It allows creating a file (binary or csv) locally, and then use the COPY function with "FROM STDIN" that does not need to push the file on a remote database server. I h

Re: [SPAM] [GENERAL] COPY command & binary format

2016-05-10 Thread Cat
On Tue, May 10, 2016 at 03:00:55PM +0200, Nicolas Paris wrote: > > The way I want is : > > csv -> binary -> postgresql > > > > Is this just to be quicker or are you going to add some business logic > > while converting CSV data? > > As you mentioned ETL, I assume the second, as I don't think that >

Re: [SPAM] [GENERAL] COPY command & binary format

2016-05-10 Thread Cat
On Tue, May 10, 2016 at 01:38:12PM +0200, Nicolas Paris wrote: > The way I want is : > csv -> binary -> postgresql > > And if possible, transforming csv to binary throught java​. > > Use case is ETL process. Not sure what the point would be tbh if the data is already in CSV. You might aswell sub

Re: [SPAM] [GENERAL] COPY command & binary format

2016-05-10 Thread Nicolas Paris
2016-05-10 14:47 GMT+02:00 Moreno Andreo : > Il 10/05/2016 13:38, Nicolas Paris ha scritto: > > 2016-05-10 13:04 GMT+02:00 Moreno Andreo : > >> 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

Re: [SPAM] [GENERAL] COPY command & binary format

2016-05-10 Thread Moreno Andreo
Il 10/05/2016 13:38, Nicolas Paris ha scritto: 2016-05-10 13:04 GMT+02:00 Moreno Andreo : Il 10/05/2016 12:56, Nicolas Paris ha scritto:

Re: [SPAM] [GENERAL] COPY command & binary format

2016-05-10 Thread Nicolas Paris
2016-05-10 13:04 GMT+02:00 Moreno Andreo : > 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 fil

Re: [SPAM] [GENERAL] COPY command & binary format

2016-05-10 Thread Moreno Andreo
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/sq