News for hackers. Stuff that matters.
Re:PostgreSQL vs. MS SQL by jackmaney on Monday November 17, 2014 @06:07PM (#8621338)
Although I've had experience with both PostgreSQL and MS SQL, well over 90% of my experience is with the former.

When exporting data to CSV where a text field contains the delimiter, PostgreSQL will do the correct thing every time: wrap that field in quotes. MS SQL...will not.

Re:PostgreSQL vs. MS SQL by Pherdnut on Monday November 17, 2014 @07:44PM (#8621801)
That's where MS tends to bug me. Why wasn't that fixed within a few hours of somebody discovering the problem? I ran into a similar issue on an app I just wrote that spits out CSVs. I googled, found a stackoverflow post about how to escape CSVs properly with Excel in mind, and fixed it. One primarily JavaScript dev and maybe an hour of testing, diagnosis and repair.