how does postgres convert tables to CSV? in ubuntu virtual machines

google found
COPY (
SELECT name, category_name
FROM products
LEFT JOIN categories ON categories.id = products.category_id
)
TO"/ path/to/output.csv"
WITH csv;

but using this will prompt ERROR: relative path not allowed for COPY to file

ask for the correct export posture