PSQL run from shell script - command not found?

Question

I try to execute an PSQL from shell, and the thing is - it returns the error "command not found". I have a shell script in which there're lines:

ID3=`more DATA/Id3.txt`
psql -h localhost test test -Atc "SELECT id, reference, timestamp FROM restricted WHERE id='`$ID3`'"

In the Id3.txt there's only the ID. When the psql command is written and executed direct through prompt - there's no problem at all and correct value is returned. When executed with a .sh file - error "command not found" is brought up. I have no clue why. Maybe anyone have a idea?

Do you get the same message if you run the psql -h ... command from your prompt? — fedorqui
– fedorqui, Commented Nov 25, 2013 at 14:17
when running from prompt I get the ID from DB. It won't work only when run with a script — jakkolwiek
– jakkolwiek, Commented Nov 25, 2013 at 14:18
The error message is from the shell. The SQL command itself has nothing to do with it. The error kicks in an earlier stage. psql is not found. — Erwin Brandstetter
– Erwin Brandstetter, Commented Nov 29, 2013 at 17:30

przno · Accepted Answer · 2013-11-25 14:26:50Z

1

In your script try to add which psql to see whether you can find the executable

answered Nov 25, 2013 at 14:26

przno

3,5145 gold badges33 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

slayedbylucifer · Accepted Answer · 2013-11-25 14:27:28Z

1

Run below command on your console: whereis psql And then replace psql inyour script with the output of above command. This

answered Nov 25, 2013 at 14:27

slayedbylucifer

23.7k17 gold badges98 silver badges126 bronze badges

Collectives™ on Stack Overflow

PSQL run from shell script - command not found?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related