Copy postgres query results to file

COPY (query)
TO 'file';

COPY (select * from users)
TO '/tmp/users.csv';