X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 48376D72AA for ; Wed, 31 Aug 2005 09:55:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35494-05 for ; Wed, 31 Aug 2005 12:54:55 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 7CDB7D84C9 for ; Wed, 31 Aug 2005 09:54:53 -0300 (ADT) Received: (qmail 21607 invoked by uid 0); 31 Aug 2005 12:54:57 -0000 Received: from 213.128.122.2 by www18.gmx.net with HTTP; Wed, 31 Aug 2005 14:54:57 +0200 (MEST) Date: Wed, 31 Aug 2005 14:54:57 +0200 (MEST) From: digit-x@gmx.net To: pgsql-sql@postgresql.org MIME-Version: 1.0 References: <200508311813.18420.lawgon@thenilgiris.com> Subject: =?ISO-8859-1?Q?Re:__psql_commandline?= X-Priority: 3 (Normal) X-Authenticated: #16832529 Message-ID: <11603.1125492897@www18.gmx.net> X-Mailer: WWW-Mail 1.6 (Global Message Exchange) X-Flags: 0001 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.119 required=5 tests=[AWL=-0.059, NO_REAL_NAME=0.178] X-Spam-Level: X-Archive-Number: 200508/299 X-Sequence-Number: 22527 The error is : column "admin" doesn`t exist What the f... is that db doing? > --- Ursprüngliche Nachricht --- > Von: Kenneth Gonsalves > 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 -- 5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail +++ GMX - die erste Adresse für Mail, Message, More +++