psql -U username -d dbname < filename.sql
For Postgres versions 9.0 or earlier:
psql -U username -d dbname -1 -f filename.sql
| import ipdb; ipdb.set_trace() |
psql -U username -d dbname < filename.sql
For Postgres versions 9.0 or earlier:
psql -U username -d dbname -1 -f filename.sql