I am getting a PostgreSql error when try to run this ‘Copy table’ on my Mac desktop folder by running this command;
COPY char_data_types TO ‘myfilePathToMac’
WITH (FORMAT CSV, HEADER, DELIMITER ‘|’);
Tryin to COPY a table save it to my desktop folder on Mac and getting an error ‘ERROR: could not open file.
SQL state: 42809