PostgreSQL copy command not creating the file specified
<p>I'm trying to export some data from my PostgreSQL tables via CLI using the following:</p>

<pre><code>\COPY (SELECT * FROM table-name limit 5) TO '"C:\Users\filepath\filename.csv"' WITH CSV DELIMITER ',';
</code></pre>

<p>It spits out "COPY 5" so it appears to have succeeded, but the file is never created or modified at the location specified. What am I doing wrong? Thanks!</p>