CLI utility to display postgres database information as a tree.
Project description
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pgls-1.0.1.tar.gz
(89.5 kB
view details)
File details
Details for the file pgls-1.0.1.tar.gz
.
File metadata
- Download URL: pgls-1.0.1.tar.gz
- Upload date:
- Size: 89.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/3.7.3 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.59.0 CPython/3.9.3
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 091b211d1362184b8a06ffd4e3a521425e189b30f301eac4095b1d6211faffcf |
|
MD5 | c76241666efb610a26c3b29a7584bce5 |
|
BLAKE2b-256 | fa850ebedc1c6f976f0363517ef21126527fe648c5502fca6591d6bb7264ab1e |