Import SQL dump into PostgreSQL database

by 
psql databasename < data_base_dump

That’s the command you are looking for.

Beware: databasename must be created before importing.
Have a look at the PostgreSQL Docs Chapter 23. Backup and Restore.

More Related Contents:

  1. Keep PostgreSQL from sometimes choosing a bad query plan
  2. Copying PostgreSQL database to another server
  3. Primary keys with Apache Spark
  4. How can I put a database under git (version control)?
  5. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  6. Store query result in a variable using in PL/pgSQL
  7. Can I rollback a transaction I’ve already committed? (data loss)
  8. Kill a postgresql session/connection
  9. PostgreSQL: Drop PostgreSQL database through command line [closed]
  10. Do stored procedures run in database transaction in Postgres?
  11. how to use Blob datatype in Postgres
  12. How can I solve Postgresql SCRAM authentication problem?
  13. Convert SQLITE SQL dump file to POSTGRESQL
  14. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  15. How to login and authenticate to Postgresql after a fresh install?
  16. PostgreSQL Database Log Transaction
  17. Connect to a heroku database with pgadmin
  18. How do I automatically update a timestamp in PostgreSQL
  19. Starting and populating a Postgres container in Docker
  20. Adding a new value to an existing ENUM Type
  21. How can I import a .sql file into my Heroku postgres database?
  22. Backup/Restore a dockerized PostgreSQL database
  23. Is it possible to specify the schema when connecting to postgres with JDBC?
  24. What is the best design for a database table that can be owned by two different resources, and therefore needs two different foreign keys? [closed]
  25. Spring Security:password encoding in DB and in applicationContext
  26. How to retrieve the last autoincremented ID from a SQLite table?
  27. Synchronous database queries with Node.js
  28. XML data to PostgreSQL database [closed]
  29. Best representation of an ordered list in a database?
  30. SQL LIKE operator in Cloud Firestore?

Leave a Comment