Re: Importing directly from BCP files - Mailing list 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