Answers for "psql select export to csv"

postgresql export output table as a csv

COPY table_name TO 'file_name.csv' DELIMITER ',' CSV HEADER;

Posted by: Guest on February-07-2021

automated psql csv export script on windows

psql arco -c "copy (select url from urltable where scoreid=1 limit 25000) to '/h/u544835/data25000.csv'"

Posted by: Guest on September-22-2021

Code answers related to "psql select export to csv"