Re: Re: Select statement - Mailing list pgsql-general

From Richard Huxton
Subject Re: Re: Select statement
Date
Msg-id 001a01c0e363$e83f3da0$1001a8c0@archonet.com
Whole thread Raw
In response to Re: Re: Select statement  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List pgsql-general
From: "Thalis A. Kalfigopoulos" <thalis@cs.pitt.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


pgsql-general by date:

Previous
From: "rwell"
Date:
Subject:
Next
From: "Richard Huxton"
Date:
Subject: Re: incomplete transaction keeps table locked?