Export and import table dump (.sql) using pgAdmin
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.
Note: Make sure to remove <> from the above query except for the < between db_name & file path.
Example: psql -U postgres -d dumb_db < D:\db_dump.sql
- 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