Re: Importing directly from BCP files

On Monday, November 16, 2015 1:15 PM, Tim Uckun
<timuckun(at)gmail(dot)com> wrote:

> I don't see any documentation anywhere about the BCP format and
> as I said googling for "BCP format" gives a zillion links about
> the format files.

That's because there is no one, single "BCP format" -- the format
of a BCP file is determined by a BCP format file, which can be
created dynamically when you use BCP to generate output. There is
no way to do more than guess at how to read a BCP file without its
associated format file.

Now, the human brain is amazingly good at spotting patterns; you
might be able to infer the format of each of your BCP files by
looking at it, but the only *sure* way of interpreting it correctly
is to read the format file.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company