Rowan's World, et Cetera

Archive by month: February 2014

Securely Importing and Exporting CSV with PostgreSQL

by Rowan on 16 February, 2014

Many moons ago, I posted a surprisingly popular answer on StackOverflow regarding how to write to CSV files using PostgreSQL. The answer, in a nutshell, is the COPY statement. But there’s a catch – PostgreSQL imposes strict security limitations on the use of this statement, which are best dealt with using another feature, the SECURITY […]