'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