Hacker News Reader

CSV based export/import would involve writing to disk, sending over network then reading back from file. Select is just one copy over network, no intermediate CSV.

View on HN

You can stream CSV without writing it to a disk.

What would be the point in that?

COPY is way faster than INSERT, at least in PG.

Reply on news.ycombinator.com