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

On openSuSE 13.2

sudo zypper install freetds-tools

Ubuntu 14.04

sudo apt-get install freetds-bin

aklaver@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