概念描述
pgclimb可以将数据导出到excel
测试验证
一、安装pgclimb工具
pgclimb的地址为:https://github.com/lukasmartinelli/pgclimb
chmod +x pgclimb_linux_amd64
mv pgclimb_linux_amd64 pgclimb
二、使用pgclimb
pgclimb语法
-bash-4.2$ ./pgclimb --help
NAME:
pgclimb - Export data from PostgreSQL into different data formats
USAGE:
pgclimb [global options] command [command options] [arguments...]
VERSION:
0.2
COMMANDS:
template Export data with custom template
jsonlines Export newline-delimited JSON objects
json Export JSON document
csv Export CSV
tsv Export TSV
xml Export XML
xlsx Export XLSX spreadsheets
inserts Export INSERT statements
help, h Shows a list of commands or help for one command
GLOBAL OPTIONS:
--dbname value, -d value database (default: "postgres") [$DB_NAME]
--host value host name (default: "localhost") [$DB_HOST]
--port value, -p value port (default: "5432") [$DB_PORT]
--username value, -U value username (default: "postgres") [$DB_USER]
--ssl require ssl mode
--password value, --pass value password [$DB_PASS]
--query value, --command value, -c value SQL query to execute [$DB_QUERY]
--file value, -f value SQL query filename
--output value, -o value Output filename
--help, -h show help
--version, -v print the version
2.1 导出Excel
三张表导入到一个excel
-bash-4.2$ ./pgclimb --dbname=pepsidb --output=pepsidb.xlsx --query="select * from employees" xlsx --sheet emp
-bash-4.2$
-bash-4.2$ ./pgclimb --dbname=pepsidb --output=pepsidb.xlsx --query="select * from departments" xlsx --sheet dep
-bash-4.2$
-bash-4.2$ ./pgclimb --dbname=pepsidb --output=pepsidb.xlsx --query="select * from jobs" xlsx --sheet job
2.2 insert格式
-bash-4.2$ ./pgclimb --dbname=pepsidb --output=job.sql --query="select * from jobs" inserts
2.3 csv格式
-bash-4.2$ ./pgclimb --dbname=pepsidb --output=job.csv --query="select * from jobs" csv