I need to create script in linux. There is command like:
psql -U postgres -d ticketon -c "UPDATE "user" SET "password" = 'test'"
When I put it to quotation marks, there is mistake. When out of quotation marks, there also is error. I have tried almost everything, but still without success. Do anyone know what is correct syntax?
How a_horse_with_no_name said.
psql -U postgres -d dbName -c "UPDATE \"user\" SET \"password\" = 'test'"
I was doing something similar recently.
What you want to do is preform the logon first (psql -U postgres -d ticketon -c) and then pipe via STDIN the query you wish to preform ("UPDATE "user" SET "password" = 'test'"). In bash this will be the following:
echo "UPDATE "user" SET "password" = 'test'" | psql -U postgres -d ticketon -c
The above could work better than just using the -c command for a single command, because postgres does not like dealing with double quotes.
No need for excessive quoting if you use an sh here document:
#!/bin/sh
psql -U postgres -d ticketon <<XXX
UPDATE "user"
SET password = 'test'
WHERE username = 'James' -- I think a where clause is needed here ...
;
XXX
psql -U postgres -d ticketon -c "UPDATE \"user\" SET \"password\" = 'test'"