Skip to content

Instantly share code, notes, and snippets.

@landon9720

landon9720/psql_import_csv_with_progress.sh

Created January 28, 2016 22:22
Show Gist options
  • Save landon9720/09eaeb1ec41c87b42266 to your computer and use it in GitHub Desktop.
Save landon9720/09eaeb1ec41c87b42266 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
psql_import_csv_with_progress.sh
pv < yourfile.csv | psql -c "copy yourtable from STDIN;"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment