Re: [SQL] psql commandline

2005-08-31 Thread digit-x 
The error is :

column "admin" doesn`t exist

What the f... is that db doing?


> --- Ursprüngliche Nachricht ---
> Von: Kenneth Gonsalves <[EMAIL PROTECTED]>
> An: [email protected]
> 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

-- 
5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail
+++ GMX - die erste Adresse für Mail, Message, More +++

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [SQL] psql commandline

2005-08-31 Thread digit-x 
Thx, but already did that.

After entering the statement that way my console hangs and only ctrl-d gets
it working again.

error shown than is:

unexpected EOF while looking for matchin '"'
bash: syntax error: unexpected end of file


> --- Ursprüngliche Nachricht ---
> Von: Kenneth Gonsalves <[EMAIL PROTECTED]>
> An: [email protected]
> Betreff: Re: [SQL] psql commandline
> Datum: Wed, 31 Aug 2005 18:33:57 +0530
> 
> On Wednesday 31 Aug 2005 6:24 pm, [EMAIL PROTECTED] wrote:
> > The error is :
> >
> > column "admin" doesn`t exist
> 
> try \'admin\'
> -- 
> regards
> kg
> 
> http://www.livejournal.com/users/lawgon
> tally ho! http://avsap.org.in
> ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
> 
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>match

-- 
Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly