In PostgreSQL, COPY command used for exporting or importing data in CSV format.
simple COPY commands for export the Table data in CSV format.
postgres@boss:~$ psql
postgres=# COPY Table_Name TO '/root/Desktop/table_data_export.csv';
ERROR: could not open file "/root/Desktop/ table_data_export.csv" for writing: Permission denied
even i've done all the permission (
chmod)
and changed the owner (chown
) to postgres. Then I tried to export the same on location postgres/data, now problem get solved. postgres=# COPY Table_Name TO '/home/postgres/data/table_data_export.csv';
1 comment:
Its a file permission issue, output file path must be writable by postgres user.
Post a Comment