Skip to content

Instantly share code, notes, and snippets.

@tommyskott
Last active August 13, 2020 16:40
Show Gist options
  • Save tommyskott/78f2f1be7061812468c3965e50e22c7b to your computer and use it in GitHub Desktop.
Save tommyskott/78f2f1be7061812468c3965e50e22c7b to your computer and use it in GitHub Desktop.

PostgreSQL

Install it

Download and follow the 3 steps on: postgresapp

Login

psql

Create database

create database data_base_name;

Import dump to db

psql db_name < db_dump.pgsql

Export dump to desktop

pg_dump db_name > db_dump.pgsql

Delete db

drop database data_base_name;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment