====== Tricks & Trade for psql ======

if you use psql on the console and you want proper line wrapping and 'indentation' like python -m json.tool, enable the extended format

<code>
\x
</code>

===== COPY =====

bulk upload of a CSV file into a table

<code>
\copy sim_clusters from /tmp/sim_clusters.csv with delimiter ','
</code>
Keywords: sql psql postgresql client console