Skip to content

Instantly share code, notes, and snippets.

@letam

letam/dump-table-data.sh

Created May 5, 2020 22:09
Show Gist options
  • Save letam/82ed7a22178ee469e87d365311a443ae to your computer and use it in GitHub Desktop.
Save letam/82ed7a22178ee469e87d365311a443ae to your computer and use it in GitHub Desktop.
Download ZIP
Dump data from PostgreSQL table
Raw
dump-table-data.sh
#!/usr/bin/env bash
db_user=postgres
db_name=postgres
db_table=users_user
pg_dump -U $db_user $db_name --column-inserts -a -t $db_table
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment