Re: psql commandline

Поиск
Список
Период
Сортировка
От Zac
Тема Re: psql commandline
Дата
Msg-id df4alh$19dk$1@news.hub.org
обсуждение исходный текст
Ответ на Re: psql commandline  (digit-x@gmx.net)
Ответы Re: psql commandline
Список pgsql-sql
Дерево обсуждения 
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 <lawgon@thenilgiris.com>
>>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
> 
>

В списке pgsql-sql по дате отправления: