download postgresql data from remote server to local

steps.md

1. Access your database in remote server as psql -h '127.0.0.1' -U 'your_user' -d 'your_database'

2. \copy (select * from your_table_name) to 'your_file_name.csv' with csv;

3. Download file in your local machine scp -i your_pem_file.pem ec2-user@ip_address:/home/your_server_user/your_file.csv /home/your_local_user/Downloads/

4. Access your local database same as step 1

5. Copy data into table from file you have downloaded \copy your_table_name from '/home/your_local_machine_username/Downloads/file_name.csv' csv;