Re: Re: Select statement

On Mon, 21 May 2001, Lee Harr wrote:

> On Mon, 21 May 2001 19:26:04 +0000 (UTC), dave go <godave621(at)yahoo(dot)com> wrote:
> > Hi,
> >
> > I am trying create a new table A from table B. On B
> > (b1, b2, b3, b4 ) I would like create a table A (a1,
> > a2, a3) where a2 is b2 and b3.
> >
> > example:
> > A)
> >
> > Id, lastname, Firstname, MInit
> > ------------------------------
> >
> > B)
> >
> > Id, Name, MInit
> > ---------------
> >
>
>
> 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?...

regards,
thalis