SHELL

postgres run query from command line

## Using SQL file
PGPASSWORD=myPassword psql -h myDbHost -U myUser -p 5432 -d my_db -a -q -f /path/to/sql/file.sql
## Or
PGPASSWORD=myPassword psql -h myDbHost -U myUser -p 5432 -d my_db < /path/to/sql/file.sql

## Using command
PGPASSWORD=myPassword psql -h myDbHost -U myUser -p 5432 -d my_db -c "select * from my table limit 1;"

how to run sql script in postgresql

export PGPASSWORD=<password>
psql 
  -h <host> 
  -d <db> 
  -U <user> 
  -p 5432 
  -a 
  -q 
  -f <path_to_file>