public inbox for [email protected]help / color / mirror / Atom feed
(no subject) 2+ messages / 2 participants [nested] [flat]
* (no subject) @ 2003-04-04 12:32 rx <[email protected]> 2003-04-07 17:53 ` Re: [GENERAL] Manfred Koizar <[email protected]> 0 siblings, 1 reply; 2+ messages in thread From: rx @ 2003-04-04 12:32 UTC (permalink / raw) To: [email protected]; +Cc: pgsql-docs 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@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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [GENERAL] 2003-04-04 12:32 (no subject) rx <[email protected]> @ 2003-04-07 17:53 ` Manfred Koizar <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Manfred Koizar @ 2003-04-07 17:53 UTC (permalink / raw) To: rx <[email protected]>; +Cc: [email protected]; pgsql-docs On Fri, 4 Apr 2003 14:32:10 +0200, "rx" <[email protected]> wrote: >TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"=ddf.tif;'|psql VEIrx -U postgres >TuxFax:~ # echo 'select * from "Faxeingang" where "Filename"='ddf.tif';'|psql VEIrx -U postgres >[...] Rong, you have enumerated almost all combinations, except echo 'select * from "Faxeingang" where "Filename"='\''ddf.tif'\'';' ;-) Servus Manfred ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-04-07 17:53 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-04-04 12:32 rx <[email protected]> 2003-04-07 17:53 ` Re: [GENERAL] Manfred Koizar <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox