原 copy导出报错relative path not allowed for COPY to file
👉 本文共约140个字，系统预计阅读时间或需1分钟。
现象
psql:D:/bk/ct_bk_tb.sql:3: ERROR: relative path not allowed for COPY to file
1 2 | copy ( SELECT 'D:\Greenplum\greenplum-clients\bin\pg_dump -U gpadmin -h 192.168.88.21 --dbname=LHRDB --format=custom --file=%backupDir%\LHRDB'||tablename||'.bk --table='||d.schemaname||'.'||tablename bk1 from pg_tables d where d.schemaname in ('public') and tablename not like 'staging_gpload_reusable_%' and tablename not like 'ext_gpload_%' ) to 'Z:/bk/bk_tb.bat'; |
分析
服务器是Linux，客户端是Windows
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
