Postgresql database, how to backup data and import to another database

There are many ways to do this, and the method used here is more secure. Then there will be time to add another method.

The method is divided into three steps: Backing up data, creating a new table structure, importing data

Backup data: >>\copy table_name to '/home/bak/table_name.sql ';

Create a new table structure: Copy the SQL statements from the original table structure, delete unnecessary and inappropriate information, and run new table statements in the new database.

Import data: >>\copy table_name from '/home/bak/table_name.sql ';

Postgresql database, how to backup data and import to another database