SQL

Create a dump of the remote database using pg_dump command pg_dump --host=remote_host_name --port=remote_port_number --username=remote_database_user_name --dbname=database_name > db_export.sql You will get a dump SQL file of the remote database upon successful completion of this process.

Making a database call is an expensive operation. It involves opening a connection to the database, and the SQL query passed through this connection to the database is parsed, optimized, and then finally executed.