psql导入导出csv

导出

1
psql --dbname=emgda --host=192.168.2.10 --username=emgda -c "COPY (select * from tag order by id) TO STDOUT with csv header" > /home/emgda/Downloads/tag.csv

导入

1
copy elementaccess from '/home/emgda/Documents/A.csv' with csv header
作者

Wei Mo

发布于

2022-03-11

更新于

2023-11-24

许可协议

评论