Export and import table dump (.sql) using pgAdmin

In pgAdmin, select the required target schema in object tree (databases ->your_db_name -> schemas -> your_target_schema)
Click on Plugins/PSQL Console (in top-bar)
Write \i /path/to/yourfile.sql
Press enter

An another way, you can do it easily with CMD on Windows

Put your installed version (mine is 11).

cd C:\Program Files\PostgreSQL\11\bin\

and run simple query

psql -U <postgre_username> -d <db_name> < <C:\path\data_dump.sql>

enter password then wait the final console message.

postgresql postgresql-9.2 pgadmin

Using PgAdminstep 1:select schema and right click and go to Backup..

step 2:Give the file name and click the backup button.

step 3:In detail message copy the backup file path.

step 4:

Go to other schema and right click and go to Restore. (see step 1)

step 5:

In popup menu paste aboved file path to filename category and click Restore button.

CodeHunter