How to save query result to csv file?

Question

PostgreSQL

How to keep this business? linux operating system
do this, but the file does not appear, the request is processed

COPY (SELECT  aicraft.id,auto.uri, auto.expires_at, auto.created_at, auto.updated_at
FROM aicraft  LEFT OUTER JOIN aicraft ON aicraft_id = auto.id ) TO '/tmp/stst.csv' ;

Answer 1

If this is a one-time event, then install Navicat - there is an export of results to CSV. The program is paid, but a trial for 2 weeks should be enough.