Home > mailing lists

COPY command & binary format - Mailing list pgsql-general

From	Nicolas Paris
Subject	COPY command & binary format
Date	May 10, 2016 10:56:27
Msg-id	CA+ssMORTVs9cnvaS6wOOuPcmmsT5MJ6sfDYs9h3peXqW4zOA5A@mail.gmail.com Whole thread
Responses	Re: [SPAM] COPY command & binary format Re: COPY command & binary format Re: COPY command & binary format
List	pgsql-general

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

Could I create such format from java ?

I guess this would be far faster, and maybe safer than CSVs

Thanks by advance,

From: Sameer Kumar
Date: 10 May 2016, 07:21:03
Subject: Re: Inserting into a master table with partitions does not return rows affected.

From: Moreno Andreo
Date: 10 May 2016, 11:04:07
Subject: Re: [SPAM] COPY command & binary format