pg
pg
is an alternative CLI tool for PostgreSQL
It aims to be simple to use with less commands to remember
Features
- very easy to use
- support for multiple database connections
- handy subcommands for database structure exploration
- commands autocomplete ( we all love
tab -> tab
right? :) )
- embedded sql editor for more advanced exploration
- query history navigation
Handy subcommands
Sql Editor
Config file example
Put this in your $HOME/.pg dir
connections:
- name: db1
url: postgres://user1:pass1@host1:5432/db1
- name: db2
url: postgres://user2:pass2@host2:5432/db2