Re: Importing directly from BCP files

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

> Does anybody have any documentation on what a BCP file from SQL server
> looks like?
>

That appears to depend on the -f option

https://msdn.microsoft.com/en-nz/library/ms162802.aspx

There's more details on the format files here
https://msdn.microsoft.com/en-nz/library/ms191516.aspx

Have you tried opening a file in a text editor to see what they look like?

> I have a directory full of BCP files and I would like to import them into
> PG.
>
>
The default format seems to be separating values with a tab character.

The bulk import command in PostgreSQL is COPY, so you'll likely want to
look at http://www.postgresql.org/docs/9.4/static/sql-copy.html
Let's assume you have *.bcp files in the default format with values
separated with tabs, you could open up psql and use a command something
along the lines of:

copy <table name> from '<filename>' delimiter ' '; -- <- use a tab
character between the quotes.

Of course, you'll need to create the table first with CREATE TABLE.

> Has anybody done anything like this before?
>
>
I'd imagine that it's fairly common.

--
David Rowley http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Training & Services