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:~ # psqlDescriptionpsql 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. --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] |