My general answer to this is to make sure whatever thing I'm building understands Pg COPY TSV syntax - specified by https://www.postgresql.org/docs/current/sql-copy.html under 'text format' - and export to/import from that.
It's nice to have something that plays nicely with awk/cut/diff/etc. and can be committed into a git (or elsevcs) repo.
(I'm not specifically wed to COPY as the form, but given it's well known and documented I've found it a good default)
It's nice to have something that plays nicely with awk/cut/diff/etc. and can be committed into a git (or elsevcs) repo.
(I'm not specifically wed to COPY as the form, but given it's well known and documented I've found it a good default)