postgres怎么在ubuntu虛擬機中將表轉(zhuǎn)出成CSV？

postgres怎么在ubuntu虛擬機中將表轉(zhuǎn)出成CSV？

google后發(fā)現(xiàn)
COPY (
SELECT name, category_name
FROM products
LEFT JOIN categories ON categories.id = products.category_id
)
TO '/path/to/output.csv'
WITH csv;

但是用這個會提示 ERROR: relative path not allowed for COPY to file

求問正確的導出姿勢