public inbox for [email protected]  

help / color / mirror / Atom feed

From: rx <[email protected]>
To: Undisclosed-Recipient:;@postgresql.org
Subject: help for postgreSQL in shell
Date: Wed, 2 Apr 2003 15:44:20 +0200
Message-ID: <004601c2f91d$f723c6c0$16e1f48a@IPSM7N> (raw)

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

[email protected]

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], Undisclosed-Recipient:;@postgresql.org
  Subject: Re: help for postgreSQL in shell
  In-Reply-To: <004601c2f91d$f723c6c0$16e1f48a@IPSM7N>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox