pg-trunk

An interactive PostgreSQL CLI tool for importing/exporting table data (json, xlsx and sql format), downloading reports of null columns, create table, alter table and insert data in interactive mode. It aims at simplifying the most complex queries such as JSONB (more features to be included in the upcoming versions).

Installation

npm install -g pg-trunk

Usage:

1. To configure database:
> pg-trunk config

2. To change database name:
> pg-trunk config --dbname database

3. To launch app:
> pg-trunk launch

4. To list all commands:
> pg-trunk commands

5. To list all queries:
> pg-trunk queries

6. To list all jsonb object queries:
> pg-trunk jsonb-object-queries

7. To list all jsonb array queries:
> pg-trunk jsonb-array-queries

8. Following command explains jsonb object queries in detail with an example:
> pg-trunk explain-jsonb-object-queries

9. Following query explains jsonb array queries with an example:
> pg-trunk explain-jsonb-array-queries