# PostgreSQL restore database from plain text dump

Connect to PostgreSQL console:

`psql`

Create the target database if it does not already exist

`CREATE DATABASE [target_db];`

Connect to target database

`\connect [target_db]`

Restore the database

`\i path/to/plain_text_dump.sql`