Skip to content

Instantly share code, notes, and snippets.

@L04DB4L4NC3R

L04DB4L4NC3R/export_csv.sh

Last active January 25, 2020 15:26
Show Gist options
  • Save L04DB4L4NC3R/bb89a162e82b3fd2f1943546d1c439b5 to your computer and use it in GitHub Desktop.
Save L04DB4L4NC3R/bb89a162e82b3fd2f1943546d1c439b5 to your computer and use it in GitHub Desktop.
Download ZIP
Heroku pg (postgresql) csv export
Raw
export_csv.sh
timestamp=`date | sed 's/\s/_/g'`
filename=technoscape_abstract_form_details_${timestamp}
heroku pg:psql -a hidden-hollows-55794 --command "\copy (select * from main_uploader) to $filename.csv csv delimiter ' ';"
Raw
heroku.md

COMMAND: sudo apt install postgresql

COMMAND: heroku pg:psql --app my-app-production

COMMAND: \copy (SELECT * FROM some_table) TO some_table.csv CSV DELIMITER ','

OUTPUT: COPY 20910

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment