Importing a SQL dump in postgres
Tue 29 November 2011 | Last updated on Tue 06 December 2022I always keep forgetting how to import a SQL dump into postgres and found it always hard to find the right documentation. So I thought lets share it:
psql -d dbname -U username -f dumpfile.sql
This should also work with files created by pgdump.