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

Re: Display SELECT

From: HK <harikrishnan(at)midascomm(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Cc: eric manceau <eric(dot)manceau(at)caramail(dot)com>
Subject: Re: Display SELECT
Date: 2002-10-24 05:12:42
Message-ID: Pine.LNX.4.33.0210241040440.15094-100000@daisy.midascomm.com (view raw or flat)
Thread:
Lists: pgsql-novice
hi,
	Also if u want to avoid placing ; at end of each line, try 
starting psql with -S option (single line). Here the newline terminates 
the query rather that ;.
Also note the changed prompt.

regards,
hari

 On Wed, 23 Oct 2002, Ludwig Lim wrote:

> 
> --- eric manceau <eric(dot)manceau(at)caramail(dot)com> wrote:
> > 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-#
> > 
>  You forgot to put a semi-colon after the SELECT
> statement.
> 
> regards,
> ludwig.
> 
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 


In response to

pgsql-novice by date

Next:From: Ludwig LimDate: 2002-10-24 05:15:39
Subject: Re: display functions
Previous:From: cristiDate: 2002-10-24 05:03:13
Subject: display functions

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