Re: Importing directly from BCP files

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: S McGraw <smcg4191(at)mtneva(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Importing directly from BCP files
Date: 2015-11-16 20:15:59
Message-ID: CAGuHJrNY20vPMfyGpF6igTwnknxYsE4esCOK43qGZT7VKgSemw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
> On openSuSE 13.2
>
> sudo zypper install freetds-tools
>
> Ubuntu 14.04
>
> sudo apt-get install freetds-bin
>
> aklaver(at)killi:~> freebcp -h
> usage: freebcp [[database_name.]owner.]table_name {in | out} datafile
> [-m maxerrors] [-f formatfile] [-e errfile]
> [-F firstrow] [-L lastrow] [-b batchsize]
> [-n] [-c] [-t field_terminator] [-r row_terminator]
> [-U username] [-P password] [-I interfaces_file] [-S server]
> [-v] [-d] [-h "hint [,...]" [-O "set connection_option on|off,
> ...]"
> [-A packet size] [-T text or image size] [-E]
> [-i input_file] [-o output_file]
>
> example: freebcp testdb.dbo.inserttest in inserttest.txt -S mssql -U guest
> -P password -c
>
>>
>>
From what I can make out this tool reads the BCP files and puts them into
an SQL server. I need to either put them into a postgres server or to
output as plain text CSV files.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johannes 2015-11-16 20:18:35 Re: update inside function does not use the index
Previous Message Alvaro Herrera 2015-11-16 19:37:22 Re: Importing directly from BCP files