pggy

    0.0.3 • Public • Published

    pggy

    NPM NPM

    Postgres terminal UI using blessed and knex js

    pgy

    Usage

    npm install -g pggy

    Create a .pggyrc file in your home (or current directory) with the following;

    {
        "hostname": "localhost",
        "password": "",
        "username": "bulkan",
        "database": "chinook"
    }

    Keyboard shortcuts

    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 table
    • ENTER to run select * from <table> query on the highlighted table

    Anywhere;

    • ctrl + r anywhere to jump to the raw sql text box
    • ctrl + q to quit

    Install

    npm i pggy

    DownloadsWeekly Downloads

    2

    Version

    0.0.3

    License

    MIT

    Last publish

    Collaborators

    • bulkan