Re: Display SELECT

you are missing the ending semicolon that is needed to complete the select
statement. The reason I noticed this is because your prompt changed from
"com=#" to "com-#" (notice the change from = to -), meaning psql is waiting
for the rest of command, a semicolon, in your case.

regards,

Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474

"eric manceau"
<eric(dot)manceau(at)caramail(dot) To: pgsql-novice(at)postgresql(dot)org
com> cc:
Sent by: Subject: [NOVICE] Display SELECT
pgsql-novice-owner(at)post
gresql.org


10/23/2002 12:55 PM

Hello there,

I cannot retrieve the result of a SELECT query on the PSQL
monitor but nothing seems wrong :

com=# \d iden
Table "iden"
Attribute | Type | Modifier
-----------+-----------------------+----------
name | character varying(20) |
tel | integer |

com=# INSERT INTO iden VALUES ('germain',5689);
INSERT 18844 1
com=# SELECT * FROM iden
com-#

I use postgresql 7.1.3 on a redhat 7.2.

Thank you for any hint.
_________________________________________________________
Gagne une PS2 ! Envoie un SMS avec le code PS au 61166
(0,35€ Hors coût du SMS)

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org