Wednesday, September 23, 2015

Postgresql: import export of data

Export
copy (select * from shared_db.dt_process where process_name = 'AM_PARTITION') to '/tmp/shared_db__dt_process.csv' delimiter ',' csv header;
Import
copy shared_db.dt_process from '/tmp/shared_db__dt_process.csv';