Re: Importing directly from BCP files - Mailing list pgsql-general

From Kevin Grittner
Subject Re: Importing directly from BCP files
Date
Msg-id 3736261.4698930.1447706954167.JavaMail.yahoo@mail.yahoo.com
Whole thread Raw
In response to Re: Importing directly from BCP files  (Tim Uckun <timuckun@gmail.com>)
List pgsql-general
On Monday, November 16, 2015 1:15 PM, Tim Uckun
<timuckun@gmail.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

pgsql-general by date:

Previous
From: Johannes
Date:
Subject: Re: update inside function does not use the index
Next
From: Johannes
Date:
Subject: Re: update inside function does not use the index