Run SQL file using PSql client in Postgres Db on windows 10

Most of the time people struggle with running the postgres sql file with psql from the command prompt

Prequisites:
– Postgres need to be install on your windows 10 machine
– psql.exe path must be included in Environment variable path

Create an sql file with the command “SELECT Now()” and save with name test.sql .

To run this file open command prompt and navigate to the file path.
run command > psql -U postgres -d postgres -a -f ./test.sql
result: time printed


h
ere -U parameter is for username which postgres and -d is database which is again postgres

Run this file from the another sql file. To do this create a sql file in same directory and type the command “\i ./test.sql” and save with name test2.sql.

Now to run test2.sql
run command > psql -U postgres -d postgres -a -f ./test2.sql
result time printed

Now to run the file with host name
>psql -h <HostName> -p 5432 -U postgres -d <DatabaseName> -a -f ./test2.sql
for more information refer to this link

Please leave your comments…

Leave a Reply

Your email address will not be published.