Thread: Importing dump file from MS SQL to PSQL 9.3

On Sun, Aug 23, 2015 at 06:35:41PM +0800, Freeda Suing wrote:
> Hi,
>
> Is there a straightforward way to import data to a PSQL version 9.1 from an
> MS SQL database server?
>
> If not, can you suggest any strategies on how to do it?

pgloader. It's not without its issues but I've successfully tossed a mysql db
at pgsql with it and it claims mssql support.

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

--
  "A search of his car uncovered pornography, a homemade sex aid, women's
  stockings and a Jack Russell terrier."
    - http://www.dailytelegraph.com.au/news/wacky/indeed/story-e6frev20-1111118083480