Skip to content

Instantly share code, notes, and snippets.

@luizpicolo

luizpicolo/pg_dump

Last active December 30, 2020 00:45
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 luizpicolo/d11982beaaf8b45f79dd to your computer and use it in GitHub Desktop.
Save luizpicolo/d11982beaaf8b45f79dd to your computer and use it in GitHub Desktop.
Download ZIP
pg_dump only inserts
Raw
pg_dump
pg_dump -h localhost -p 5432 -U postgres --data-only --column-inserts deltaengenhariams > table.sql
pg_dump -U db_user -W -F t db_name > /path/to/your/file/dump_name.tar
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment