On Wednesday 31 Aug 2005 6:49 pm, Zac wrote:
> su - postgres -c "psql --dbname database --command \"UPDATE users
> SET pin=12345 WHERE login='admin';\""
works - good thing to know
--
regards
kg
http://www.livejournal.com/users/lawgon
tally ho! http://avsap.org.in
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
On Wednesday 31 Aug 2005 6:43 pm, [EMAIL PROTECTED] wrote:
> After entering the statement that way my console hangs and only
> ctrl-d gets it working again.
the problem is that the quotes round 'admin' are needed to tell psql
that this is a value - but i have no idea how to create the quotes
on
ot;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: pgs
on: Kenneth Gonsalves <[EMAIL PROTECTED]>
> An: pgsql-sql@postgresql.org
> 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
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)-
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
ಇಂಡ್ಲಿನ
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 +053
