From: | "rx" <rong(dot)xie(at)stud(dot)tu-muenchen(dot)de> |
---|---|
To: | "pgadmin-hackers" <pgadmin-hackers(at)postgresql(dot)org>, <pgadmin-support(at)postgresql(dot)org>, <pgsql-docs(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>, <pgsql-general-owner(at)postgresql(dot)org> |
Subject: | psql in shell |
Date: | 2003-04-04 12:28:02 |
Message-ID: | 005e01c2faa5$a31056a0$16e1f48a@IPSM7N |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgadmin-support pgsql-docs pgsql-general |
hallo,
Can you help me for my another question?
It work good as under in shell without "where-condition" .
TuxFax:~ # echo 'select * from "Faxeingang";'|psql VEIrx -U postgres
PS: VEIrx is database name. Faxeingang is table name. In SuSE Linux 8.0, bash, postgreSQL7.2.2
DatumFaxeingang | Filename | CSID
------------------------+-------------------------+-----------
2003-04-03 17:30:45+02 | 2003_04_03_17_30_45.tif | Fax
2003-04-04 10:01:01+02 | df.tif | ds
2003-04-04 10:01:04+02 | ddf.tif | aa
(36 rows)
TuxFax:~ #
It work good as under in psql with "where-condition" .
PS: VEIrx is database name. Faxeingang is table name. Filename is column name.
postgres(at)TuxFax:/root> psql VEIrx
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
VEIrx=# select * from "Faxeingang" where "Filename"='ddf.tif';
DatumFaxeingang | Filename | CSID
------------------------+----------+------
2003-04-04 10:01:04+02 | ddf.tif | aa
(1 row)
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
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"='ddf.tif';'|psql VEIrx -U postgres
ERROR: Relation "ddf" does not exist
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"="ddf.tif";'|psql VEIrx -U postgres
ERROR: Attribute 'ddf.tif' not found
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"="'ddf.tif'";'|psql VEIrx -U postgres
ERROR: Attribute 'ddf.tif' not found
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=""ddf.tif"";'|psql VEIrx -U postgres
ERROR: zero-length delimited identifier
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=''ddf.tif'';'|psql VEIrx -U postgres
ERROR: Relation "ddf" does not exist
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=/ddf.tif/;'|psql VEIrx -U postgres
ERROR: parser: parse error at or near ";"
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=/ddf.tif/'|psql VEIrx -U postgres
ERROR: parser: parse error at or near ""
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=/'ddf.tif'/;'|psql VEIrx -U postgres
ERROR: parser: parse error at or near ";"
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"='/ddf.tif/';'|psql VEIrx -U postgres
ERROR: parser: parse error at or near ";"
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"="/ddf.tif/";'|psql VEIrx -U postgres
ERROR: Attribute '/ddf.tif/' not found
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=\"ddf.tif"\;'|psql VEIrx -U postgres
invalid command \"ddf.tif"
ERROR: parser: parse error at or near ""
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=\"ddf.tif\";'|psql VEIrx -U postgres
invalid command \"ddf.tif
ERROR: parser: parse error at or near ""
TuxFax:~ # echo "select * from "Faxeingang" where "Filename"=\"ddf.tif\";"|psql VEIrx -U postgres
ERROR: Relation "faxeingang" does not exist
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=/"ddf.tif/";'|psql VEIrx -U postgres
ERROR: Attribute 'ddf.tif/' not found
TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=/"ddf.tif"/;'|psql VEIrx -U postgres
ERROR: parser: parse error at or near ";"
TuxFax:~ #
thank you very much for your Help!
best regards!
rong
From | Date | Subject | |
---|---|---|---|
Next Message | frank_lupo | 2003-04-06 08:48:06 | RE: Question send modification |
Previous Message | Dave Page | 2003-04-04 07:06:45 | Re: Question send modification |
From | Date | Subject | |
---|---|---|---|
Next Message | rx | 2003-04-04 12:32:10 | |
Previous Message | Dave Page | 2003-04-03 20:37:53 | Re: PostgreSQL 7.3/RH 9/PGAdmin Not a good combo? |
From | Date | Subject | |
---|---|---|---|
Next Message | rx | 2003-04-04 12:32:10 | |
Previous Message | Ian Barwick | 2003-04-03 21:19:01 | Re: help for postgreSQL in shell |
From | Date | Subject | |
---|---|---|---|
Next Message | rx | 2003-04-04 12:32:10 | |
Previous Message | mlw | 2003-04-04 12:21:49 | Re: [HACKERS] OSS database needed for testing |