Skip to content

Instantly share code, notes, and snippets.

@StaverDmitry

StaverDmitry/pg_dump_table.sh

Last active May 3, 2019 08:29
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 StaverDmitry/735a81c9e951006884189f0bbc8be8d5 to your computer and use it in GitHub Desktop.
Save StaverDmitry/735a81c9e951006884189f0bbc8be8d5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pg_dump_table.sh
pg_dump --encoding=utf8 --no-owner --username username --format plain --verbose --table public.table_name db_name --file "filename"
psql --username=username db_name -f filename
@StaverDmitry
Copy link
Author

pg_dump -U username -W -F t database > /tmp/sail_test_dump_20190503
pg_restore -U username -v -d database ../dumps/test_dump

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