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

help for postgreSQL in shell

From: "rx" <rong(dot)xie(at)stud(dot)tu-muenchen(dot)de>
To: <"Undisclosed-Recipient:;"(at)postgresql(dot)org>
Subject: help for postgreSQL in shell
Date: 2003-04-02 13:44:20
Message-ID: 004601c2f91d$f723c6c0$16e1f48a@IPSM7N (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-docspgsql-general
Hallo,

I have a question in postgreSQL. I need your help!

I execute the psql as PostgreSQL 7.2 devel Documentation. 

But there is an Error:"ERROR: Relation "faxeingang" does not exist".

But the table "Faxeingang" is actually exist in Database "data"

my system: SuSE Linux 8.0, PostgreSQL 7.2.2, bash.

data is datebaseName.

faxeingang is TableName.

----------------------------------------------------------------------------------------------------------------------

Under is my command:

TuxFax:~ # echo "\x \\ select * from "Faxeingang";" | psql -U postgres data

Expanded display is on.

invalid command \

TuxFax:~ # echo "select * from "Faxeingang";" | psql -U postgres data

ERROR: Relation "faxeingang" does not exist

TuxFax:~ # echo "select * from Faxeingang;" | psql -U postgres data

ERROR: Relation "faxeingang" does not exist

TuxFax:~ # echo "select * from ""Faxeingang"";" | psql -U postgres data

ERROR: Relation "faxeingang" does not exist

TuxFax:~ # psql data -U postgres -c "select * from "Faxeingang""

ERROR: Relation "faxeingang" does not exist

TuxFax:~ # psql data -U postgres -c "select * from Faxeingang"

ERROR: Relation "faxeingang" does not exist

TuxFax:~ # psql data -U postgres -c "select * from ""Faxeingang"""

ERROR: Relation "faxeingang" does not exist

TuxFax:~ # 

*************************************************************************************
PostgreSQL 7.2 devel Documentation

psql
Name
psql --  PostgreSQL interactive terminal 
Synopsis
psql [option...] [dbname [username]]

Description
psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results. Alternatively, input can be from a file. In addition, it provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks. 

Options
-c command
--command command 

Specifies that psql is to execute one command string, command, and then exit. This is useful in shell scripts. 

command must be either a command string that is completely parsable by the server (i.e., it contains no psql specific features), or it is a single backslash command. Thus you cannot mix SQL and psql meta-commands. To achieve that, you could pipe the string into psql, like this: echo "\x \\ select * from foo;" | psql. 

If "autocommit" is on, multiple queries in a single string are processed in a single transaction. 

***********************************************************************************************************

thank you very very Much!

rong

rong(dot)xie(at)stud(dot)tum(dot)de

Responses

pgsql-docs by date

Next:From: Oliver ElphickDate: 2003-04-02 15:21:28
Subject: PDF docs for 7.3?
Previous:From: hedi gazzahDate: 2003-04-02 13:40:28
Subject: Need your help

pgadmin-hackers by date

Next:From: Jean-Michel POUREDate: 2003-04-02 17:08:40
Subject: Re: Qeustion pgadmin2 develop
Previous:From: Andreas PflugDate: 2003-04-02 13:40:30
Subject: Re: Qeustion pgadmin2 develop

pgsql-general by date

Next:From: Johnson, ShaunnDate: 2003-04-02 14:00:33
Subject: the results from a query - question
Previous:From: Mike MascariDate: 2003-04-02 12:54:37
Subject: Re: Is it possible for Postgresql to interact with Transaction

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