Skip to content

Instantly share code, notes, and snippets.

@noherczeg

noherczeg/pg_data_dump.sql

Last active November 30, 2015 02:39
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save noherczeg/d7dd1601160a374d263b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save noherczeg/d7dd1601160a374d263b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pg_data_dump.sql
-- -h Host
-- -p Port
-- -U user name
-- -w No password
-- -F Format
-- -O No owner
-- -a Data only
-- -x No privileges
-- -v Verbose
-- -f File target
-- -n Schema
pg_dump -h localhost -p 5432 -U car -w -F custom -O -a -x -v -f "C:\Users\xxx\Desktop\test.backup" -n car car
pg_restore -h localhost -p 5432 -d car -n car -U car -w -v c:\Users\xxx\Desktop\test.backup
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment