postgresql 表的导出与导入数据

#!/bin/bash

set -e
set -x

# 导出数据
export PGPASSWORD='db user passwd'
psql -h host -U user -d dbname -c "\copy ( select column1, column2, column3 from table )  to export.data"

# 导入数据
export PGPASSWORD='db user passwd'
psql -h host -U user -d dbname -c "\copy table(column1, column2, column3) from  import.data"
版权声明：本文为u011944141原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。