search

dwyl / learn-postgresql

🐘 Learn how to use PostgreSQL and Structured Query Language (SQL) to store and query your relational data. 🔍
212 stars 23 forks source link

pgcli - a "user friendly" postgresql command line interface with auto-completion #46

Open nelsonic opened 6 years ago

nelsonic commented 6 years ago

Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting. https://www.pgcli.com image

Trying this out. 

brew install pgcli
nelsonic commented 6 years ago

Tried to run:

pgcli

Got Error:

FATAL:  database "Admin" does not exist

Had to run the command with the database name. e.g:

pgcli app_dev
nelsonic commented 6 years ago

to create the {user} db simply run createdb in your terminal. thanks to: https://stackoverflow.com/questions/17633422/psql-fatal-database-user-does-not-exist