3 ms·

Or wouldn't COPY from CSV be much faster?

• 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 ago
    You can stream CSV without writing it to a disk.
    • edgyquant 3y ago
      What would be the point in that?
      • vmfunction 3y ago
        COPY is way faster than INSERT, at least in PG.
• jasonjmcghee 3y ago
  Fwiw you'd lose type information. Parquet / arrow are much more appropriate here