Exporting/Importing data from SQL Server 2014 to PostgreSQL 9.5 with tab delimited files
(CSV is not a good option for me because of the text has commas in it and from what I am reading PG doesn't like double quotes)


Sure Pg accepts double quotes. See COPY


  QUOTE Specifies the quoting character to be used when a data value is quoted. The default is double-quote. This must be a single one-byte character. This option is allowed only when using CSV format.


You don't even have to do anything..

COPY foo FROM 'asdf.csv' WITH (FORMAT CSV);



  It looks to me like COPY doesn't recognize the tab, even though when I view the file it is tab delimited. There are no NULL values in this file btw.


If you want to use tabs, just set that up.

COPY foo FROM 'asdf.csv' WITH (FORMAT CSV, DELIMITER E'\t');