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
Firstly, I have no idea about pgAdmin4
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.
-----#### 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