Skip site navigation (1) Skip section navigation (2)

Re: Display SELECT

From: "Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)com>
To: eric(dot)manceau(at)caramail(dot)com
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-novice-owner(at)postgresql(dot)org
Subject: Re: Display SELECT
Date: 2002-10-23 16:01:11
Message-ID: OFEBBF351A.209D1989-ON86256C5B.0057B7C6@ipaper.com (view raw or flat)
Thread:
Lists: pgsql-novice
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






pgsql-novice by date

Next:From: Ludwig LimDate: 2002-10-23 16:05:32
Subject: Re: a rule question
Previous:From: Ludwig LimDate: 2002-10-23 15:58:13
Subject: Re: Display SELECT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group