Postgres / PSQL importing a database

When you have backed up a database, and are restoring it (and if you are using the PSQL command line tool), don’t forget to add the database name to the end of the command line:

psql -U postgres -h hostname  -f file_you_want_to_import "**database_name**"

Don’t forget the double quotes.

Author | Miles Davenport

Career programmer, who designs, assembles, fixes, and supports customers, software and systems.