pgls

CLI utility to display postgres database information as a tree.

Installation

pip install pgls

Usage

Basic example

pgls postgres://user:password@db.example.com
# shows all databases and all nested entities

Sort by size

pgls --sort=size postgres://user:password@db.example.com
# shows heavier databases and tables first

Hide some information (also this speeds up gathering)

pgls --hide-columns postgres://user:password@db.example.com
# shows databases and tables without it's columns

pgls --hide-tables --hide-views --hide-indexes postgres://user:password@db.example.com
# shows only databases