Skip site navigation (1) Skip section navigation (2)

psql in shell

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 (view raw or flat)
Thread:
Lists: pgadmin-hackerspgadmin-supportpgsql-docspgsql-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

Responses

pgsql-docs by date

Next:From: rxDate: 2003-04-04 12:32:10
Subject:
Previous:From: Ian BarwickDate: 2003-04-03 21:19:01
Subject: Re: help for postgreSQL in shell

pgsql-general by date

Next:From: rxDate: 2003-04-04 12:32:10
Subject:
Previous:From: mlwDate: 2003-04-04 12:21:49
Subject: Re: [HACKERS] OSS database needed for testing

pgadmin-hackers by date

Next:From: frank_lupoDate: 2003-04-06 08:48:06
Subject: RE: Question send modification
Previous:From: Dave PageDate: 2003-04-04 07:06:45
Subject: Re: Question send modification

pgadmin-support by date

Next:From: rxDate: 2003-04-04 12:32:10
Subject:
Previous:From: Dave PageDate: 2003-04-03 20:37:53
Subject: Re: PostgreSQL 7.3/RH 9/PGAdmin Not a good combo?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group