使用cmd行参数将PSQL表导出到CSV文件

psql -U your_username -d your_database -c "\copy (SELECT * FROM your_table) TO 'output.csv' WITH CSV HEADER"

psql -U myuser -d mydb -c "\copy (SELECT * FROM employees) TO 'employees.csv' WITH CSV HEADER"

hostname:port:database:username:password

localhost:5432:mydb:myuser:mypassword

chmod 600 ~/.pgpass

export PGPASSWORD='mypassword'
psql -U myuser -d mydb -c "\copy (SELECT * FROM employees) TO 'employees.csv' WITH CSV HEADER"

#!/bin/bash

# 设置数据库连接参数
DB_USER="myuser"
DB_NAME="mydb"
TABLE_NAME="employees"
OUTPUT_FILE="employees.csv"

# 设置密码（可选）
export PGPASSWORD='mypassword'

# 执行导出命令
psql -U $DB_USER -d $DB_NAME -c "\copy (SELECT * FROM $TABLE_NAME) TO '$OUTPUT_FILE' WITH CSV HEADER"

# 清除密码环境变量
unset PGPASSWORD

echo "Table $TABLE_NAME has been exported to $OUTPUT_FILE"