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

\x

bulk upload of a CSV file into a table

\copy sim_clusters from /tmp/sim_clusters.csv with delimiter ','

Keywords: sql psql postgresql client console