Added by: bluxmit
Apr 23, 2023
Version

~> pgclimb

Description
Export data from PostgreSQL into different data formats
Links
Install (execute in workspace terminal)
wrk install pgclimb==0.3
Remarks and hints
# From local Postgres instance
pgclimb --host localhost --port 5432 --dbname abc --username abc --query "SELECT * FROM distributors" -o /home/project/distributors.csv csv

# From remote Postgres instance
pgclimb --host my-postgres-host --port 5432 --dbname mydb --username postgres --password xxxxxxxxxxx --query "SELECT * FROM phonebook" -o /home/project/phone.csv csv
pgclimb --host my-postgres-host --port 5432 --dbname mydb --username postgres --password xxxxxxxxxxx --query "SELECT * FROM phonebook" -o /home/static-server/phone.html html
Scripts
# Istall script # Start script

compatible with all workspaces

no compatibility requirements