I am trying to import a database dump (.sql) using pgAdmin. I want to do it using only the GUI, not the PSQL Console (where I can import the sql dump using
\i /path/to/yourfile.sql on Unix or
\i C:\\yourfile.sql on Windows). Is that possible? If so, how?
The new import tool seems to be able to only import data in a table:
The restore function doesn't seem to accept .sql:
Lastly, I cannot load the .sql I'm trying to import in the query builder, as it is too large (25 GB).