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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgsql-docs pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Michel POURE | 2003-04-02 17:08:40 | Re: Qeustion pgadmin2 develop |
Previous Message | Andreas Pflug | 2003-04-02 13:40:30 | Re: Qeustion pgadmin2 develop |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2003-04-02 15:21:28 | PDF docs for 7.3? |
Previous Message | hedi gazzah | 2003-04-02 13:40:28 | Need your help |
From | Date | Subject | |
---|---|---|---|
Next Message | Johnson, Shaunn | 2003-04-02 14:00:33 | the results from a query - question |
Previous Message | Mike Mascari | 2003-04-02 12:54:37 | Re: Is it possible for Postgresql to interact with Transaction |