psql to csv
-- Client side -This approach does the file handling on the client side \Copy (Select * From foo) To '/tmp/test.csv' With CSV DELIMITER ',' HEADER -- Server side - This approach runs entirely on the remote server Copy (Select * From foo) To '/tmp/test.csv' With CSV DELIMITER ',' HEADER;
Source: stackoverflow.com
jq to csv
jq -r '(.[0] | keys_unsorted) as $keys | $keys, map([.[ $keys[] ]])[] | @csv'
Source: stackoverflow.com
run postgresql dump to csv
\copy (SELECT * FROM persons) to 'C:\tmp\persons_client.csv' with csv
Source: www.postgresqltutorial.com
csv into data postgres
COPY table_name FROM 'C:\Users\Public\Documents\ert.txt' DELIMITER ',' CSV -- make sure to put the file in public folder in windows -- Or temp folder in linux/mac -- because it might ask for some permissions...