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.manceau@caramail.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
>