'Export table to a csv file in DBeaver with command
I am using the following command to export the data
\copy (select * From table_name) To 'my_path' With CSV DELIMITER ',' HEADER;
But I get error syntax error at or near "\".
If I use
copy (select * From table_name) To 'my_path' With CSV DELIMITER ',' HEADER;
I get the error COPY TO instructs the PostgreSQL server process to write a file. You may want a client-side facility such as psql's \copy.
I really do not know which command I should run. Thanks in advance for your help:))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
