Skip to content

Instantly share code, notes, and snippets.

@oniestel

oniestel/import_tsv_to_dockerized_postgres.sh

Created October 18, 2018 15:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save oniestel/7c64c58f4c69a0c4585ba5255a738c99 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save oniestel/7c64c58f4c69a0c4585ba5255a738c99 to your computer and use it in GitHub Desktop.
Download ZIP
Import *.tsv file to dockerized postgres from host
Raw
import_tsv_to_dockerized_postgres.sh
#!/bin/bash
cat <file>.tsv | docker exec -i <container> psql -d <database> -U user -c "COPY <table> FROM STDIN"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment