Be quiet... it is not a db problem: your shell interprets "'" characters
before sending them to psql so your query becomes
UPDATE users SET pin=12345 WHERE login=admin;
and column admin (not the literal 'admin') doesn't really exist!
Try this:
su - postgres -c "psql --dbname database --command \"UPDATE users SET
pin=12345 WHERE login='admin';\""
The error is :
column "admin" doesn`t exist
What the f... is that db doing?
--- Ursprüngliche Nachricht ---
Von: Kenneth Gonsalves <[EMAIL PROTECTED]>
An: pgsql-sql@postgresql.org
Betreff: Re: [SQL] psql commandline
Datum: Wed, 31 Aug 2005 18:13:18 +0530
On Wednesday 31 Aug 2005 6:00 pm, dIGITx wrote:
su - postgres -c 'psql --dbname database --command "UPDATE users
SET pin=12345 WHERE login='admin';"'
works for me - what is the error you are getting?
--
regards
kg
http://www.livejournal.com/users/lawgon
tally ho! http://avsap.org.in
ಇಂಡ�ಲಿನಕ�ಸ வாழ�க!
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
