Home > mailing lists

Re: Column names for INSERT with query - Mailing list pgsql-general

From	bricklen
Subject	Re: Column names for INSERT with query
Date	August 23, 2013 01:33:31
Msg-id	CAGrpgQ8AStN+SDqmaQ2ajgApxkq2dYNN9ViRumyqErsXPonCAg@mail.gmail.com Whole thread Raw
In response to	Column names for INSERT with query (Robert James <srobertjames@gmail.com>)
List	pgsql-general

On Thu, Aug 22, 2013 at 3:30 PM, Robert James <srobertjames@gmail.com> wrote:

I would like to:

INSERT INTO t
SELECT * FROM r, (x + y) AS field3

INSERT INTO t (col1, col2, col3)

SELECT ...

From: Robert James
Date: 23 August 2013, 01:30:41
Subject: Column names for INSERT with query

From: Ian Lawrence Barwick
Date: 23 August 2013, 01:36:23
Subject: Re: Column names for INSERT with query