Re: Display SELECT

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
>