piggy
Postgres terminal UI using blessed and Knex.js.
Currently a work in progress. There is a few issues & enhancements that need to be done.
See the issues in here & this Trello board
- At the moment Does not support editing records. Hopefully it will be implemented soon.
- viewing of tables in the database
- running raw queries
npm install -g pggy
- There is a dependency on libpq_dev that may also need to be installed before this will complete succesfully.
Create a .pggyrc
file in your home (or current directory) with the following;
{
"hostname": "localhost",
"password": "",
"username": "bulkan",
"database": "chinook"
}
While the table list has focus;
d
to drop the table that is highlighted (a confirmation is shown)i
to show a list of columns on the currently highlighted tableENTER
to runselect * from <table>
query on the highlighted table
Anywhere;
ctrl + r
anywhere to jump to the raw sql text boxctrl + q
to quit
MIT