Installing command line tool with pgAdmin4 I have pgAdmin4 and the latest version of PostgreSQL installed on my machine. When I tried to insert large amount of data using INSERT statements contained in a .sql file of size 40 MB, 50MB and above, the app crashed. Hence, I am wondering if dumping heavy data using those sql files via command line is a good idea? If yes, then from where can I install that command line utility in pgAdmin4 ?
Firstly, I have no idea about pgAdmin4

Secondly, It would take a lot of time when executing a large SQL file. Please consider using pg_dump (custom format) &amp; pg_restore to enhance your performance.


  Output a custom-format archive suitable for input into pg_restore.
  Together with the directory output format, this is the most flexible
  output format in that it allows manual selection and reordering of
  archived items during restore. This format is also compressed by
  default.


For example:

-----#### Exporting large table with custom format
pg_dump -h your_host -p 5432 -U user_name  --format custom --no-password   --encoding UTF8  --no-security-labels --no-tablespaces --table=your_schema_name.your_table_name --verbose --file your_file_name.backup --schema your_schema_name your_database_name  

-----#### Importing large table with custom format
pg_restore -h your_host -p 5432 -U user_name --dbname=your_database_name --role=user_name  --format custom --no-tablespaces --schema=your_schema_name --verbose your_file_name.backup