postgres run query from command line

Tiago F2 answered on March 6, 2022 Popularity 10/10 Helpfulness 4/10

answer postgres run query from command line

related how to run sql script in postgresql

postgres run query from command line

Comment

## 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;"

Popularity 10/10 Helpfulness 4/10 Language shell

Source: stackoverflow.com

Tags: command-line shell

Link to this answer
Share Copy Link

Contributed on Jun 16 2022

Tiago F2

0 Answers Avg Quality 2/10

Closely Related Answers

how to run sql script in postgresql

Comment

-1

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

Popularity 10/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: postgresql p

Link to this answer
Share Copy Link

Contributed on Mar 06 2022

Injury

0 Answers Avg Quality 2/10

postgres run query from command line

Contents

More Related Answers

postgres run query from command line

Closely Related Answers

how to run sql script in postgresql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.