Skip to content

Instantly share code, notes, and snippets.

@dmitrylitmanovich

dmitrylitmanovich/README.MD

Last active October 26, 2022 10:37
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dmitrylitmanovich/9ad7deeede0a87b0ebba71e6f5dd83c6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dmitrylitmanovich/9ad7deeede0a87b0ebba71e6f5dd83c6 to your computer and use it in GitHub Desktop.
Download ZIP
restore using psql
Raw
README.MD 
psql -U username -d dbname < filename.sql

For Postgres versions 9.0 or earlier:

psql -U username -d dbname -1 -f filename.sql
@dmitrylitmanovich
Copy link
Author

dmitrylitmanovich commented Oct 26, 2022

pg_restore -U username -d dbname -1 filename.dump

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