Quick Links

COPY command & binary format

From:	Nicolas Paris <niparisco(at)gmail(dot)com>
To:	Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject:	COPY command & binary format
Date:	2016-05-10 10:56:20
Message-ID:	CA+ssMORTVs9cnvaS6wOOuPcmmsT5MJ6sfDYs9h3peXqW4zOA5A@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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,

Re: [SPAM] COPY command & binary format at 2016-05-10 11:04:01 from Moreno Andreo
Re: COPY command & binary format at 2016-05-10 11:06:53 from Sameer Kumar
Re: COPY command & binary format at 2016-05-10 12:39:50 from Pujol Mathieu

	From	Date	Subject
Next Message	Moreno Andreo	2016-05-10 11:04:01	Re: [SPAM] COPY command & binary format
Previous Message	Sameer Kumar	2016-05-10 07:20:42	Re: Inserting into a master table with partitions does not return rows affected.