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.manceau@caramail.       To:     pgsql-novice@postgresql.org
    
                    com>                          cc:
    
                    Sent by:                      Subject:     [NOVICE] Display SELECT
    
                    pgsql-novice-owner@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@postgresql.org