$ psql -U user_name -d database_name -f file.sql When used, the psql command will behave as if the commands contained in the SQL file were manually entered by a user through the command-line interface. The first method for importing a SQL file in PostgreSQL is to use the input redirection operator < which causes a program to read from a file instead of the standard input. Importing a SQL file using the psql command In this post, we’ll discuss how to import and execute a SQL file into a PostgreSQL database using the psql command, and how to resolve the most common errors that might occur when doing so. For example, when replicating an existing database structure and its objects, or migrating thousands of database entries into another PostgreSQL instance. While most database operations can be performed manually, it is sometimes necessary to automate them using SQL files.
Create, Read, Update, Delete) operations against them. These commands are used to manage users, roles, databases, and databases objects such as tables, views, indexes, etc., by performing CRUD (i.e.
Psql is a command-line tool that enables you to connect to a PostgreSQL instance and interactively administer it by running SQL commands. $ psql -U user_name -d database_name < file.sql
