bash script : how to update database table using postgres psql and UPDATE statement

Question

How to assign a parameter/argument in postgres psql UPDATE command. I tried with the following command.

c="openssl rand -base64 6"
ab=eval $c
psql -d db_name -c "UPDATE table_name SET password = '$ab' WHERE name = 'cde'"

The above command updates the table 'table_name' in the colum 'password' as ' ' (quotes with empty string)instead of updating the value of '$ab'. The '$ab' is a string.

Could anyone help on this?

Kenyakorn Ketsombut · Accepted Answer · 2014-02-25 09:49:37Z

1

This is the way it works:

c="openssl rand -base64 6"
ab=`$c`
psql -d db_name -c "UPDATE table_name SET password = '$ab' WHERE name = 'cde'"

answered Feb 25, 2014 at 9:49

Kenyakorn Ketsombut

2,1322 gold badges28 silver badges43 bronze badges

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

1 Comment

Craig Ringer Over a year ago

Why don't you just write ab=$( openssl rand -base64 6 ) to start with?

Collectives™ on Stack Overflow

bash script : how to update database table using postgres psql and UPDATE statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related