Copy from psql

Jump to bottom

Mick Lin edited this page Nov 18, 2016 · 1 revision

psql -U <User> postgres -h 104.196.175.120

Download table to current client location

postgres=> \copy <table_name> TO '<file_name>.csv' DELIMITER ',' CSV HEADER;