PostgreSQL

pg_dump -h host -p port -U user db -f file.sql

psql -h host -U user -d db -f file.sql