3 ms·
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 C
by killingtime74 3y ago
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.
- subleq 3y agoYou can stream CSV without writing it to a disk.
- edgyquant 3y agoWhat would be the point in that?
- vmfunction 3y agoCOPY is way faster than INSERT, at least in PG.