quinta-feira, 22 de novembro de 2018

Importing files from pg_dump


For importing files generated by pg_dump command, use the command pg_restore, like that:

$ pg_restore -Uusername -hlocalhost -c -v -Fc -ddatabase < file.pg_dump

Options:
  • -U: username
  • -h: host
  • -c: drop database before recreating
  • -v: verbose mode
  • -Fc: the archive is in the custom format of pg_dump
  • -d: database

For more options look on page manpage by pg_restore.

$ man pg_restore


SQL files

In case you have a sql file to import, use this command:

$ psql -Uusername -hlocalhost -v -ddatabase < file.sql


That's all!