Re: Importing directly from BCP files

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Tim Uckun <timuckun(at)gmail(dot)com>
Cc: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Importing directly from BCP files
Date: 2015-11-16 19:37:22
Message-ID: 20151116193722.GB614468@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tim Uckun wrote:

> > 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
>
> I need to get them into a shape where copy command can process them first I
> think.

Maybe transform the format file into something for pgloader?

http://pgloader.io/howto/fixed.html

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2015-11-16 20:15:59 Re: Importing directly from BCP files
Previous Message Adrian Klaver 2015-11-16 19:34:39 Re: Importing directly from BCP files