public inbox for [email protected]  

help / color / mirror / Atom feed

From: Stephan Szabo <[email protected]>
To: rx <[email protected]>
Cc: [email protected]
Subject: Re: psql in shell
Date: Mon, 7 Apr 2003 10:29:58 -0700 (PDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <005e01c2faa5$a31056a0$16e1f48a@IPSM7N>

On Fri, 4 Apr 2003, rx wrote:

(This really didn't need to go to all those lists/people, so replying to
general only)

> Can you help me for my another question?

> But when I execute it with "where-condition" in shell as under, come a Error.
>
> PS: VEIrx is database name. Faxeingang is table name.  Filename is column name.
>
> TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=ddf.tif;'|psql VEIrx -U postgres
>
> ERROR: Relation "ddf" does not exist

Right because that's select * from "Faxeingang" where "Filename" =
ddf.tif;  (ie, a reference to a tif column of a table named ddf)

> TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"='ddf.tif';'|psql VEIrx -U postgres
>
> ERROR: Relation "ddf" does not exist

This is probably the same as the above (run just the echo part in your
shell).

> TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"="ddf.tif";'|psql VEIrx -U postgres
>
> ERROR: Attribute 'ddf.tif' not found

This is select * from "Faxeingang" where "Filename" = "ddf.tif"
(ie, a reference to a column named ddf.tif in Faxeingang.

How about something like:

echo "select * from \"Faxeingang\" where \"Filename\"='ddf.tif';"

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: psql in shell
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox