Today I came across pgcli. It is a database console for postgres with
syntax highlighting and more importantly
On OSX you can install it via
brew, more instructions here.
pgcli -d DATABASE_NAME -U USER_NAME -W:
Rails provides a command
dbconsole (aliased to
db) which just opens up the
default database console psql/mysql or something else based on adapter specified in
I wrote up a dead simple rake task to openup
pgcli using rails’ database config.
Now you can use
rake pgcli to open
pgcli. Use this instead of