Re: Re: Select statement

From: "Richard Huxton" <dev(at)archonet(dot)com>
To: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>, <missive(at)hotmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: Select statement
Date: 2001-05-23 08:39:38
Message-ID: 001a01c0e363$e83f3da0$1001a8c0@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: "Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>

> >
> > SELECT Id, Firstname||' '||lastname as Name, MInit into B from A;
>
> That's an interesting syntax which is not "visible" when doing '\h select'
in the psql monitor but exists in the online manual. Someone could add
it?...

Try "\h select into" - also listed as that in the html docs.

- Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-05-23 08:46:27 Re: NOTIFY/LISTEN Using Embedded SQL (ecpg)
Previous Message J.H.M. Dassen Ray 2001-05-23 07:49:56 Re: pg_dump fails, data integrity imperfect