Skip to content

Instantly share code, notes, and snippets.

@MikimotoH

MikimotoH/copy_to_tsv.psql

Created May 10, 2022 05:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save MikimotoH/08807c9c40d8f89c5fd853e2a0473e72 to your computer and use it in GitHub Desktop.
Save MikimotoH/08807c9c40d8f89c5fd853e2a0473e72 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL COPY TO TSV with header
Raw
copy_to_tsv.psql
copy sca_packages to '/var/lib/postgresql/sca_packages.tsv' CSV HEADER DELIMITER E'\t' NULL AS '';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment