Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert James
Subject Column names for INSERT with query
Date
Msg-id CAGYyBggz6AK0JBZdY+SwO7k0bsbM0ouL8HPqRHc9GV_NgRyuPA@mail.gmail.com
Whole thread Raw
Responses Re: Column names for INSERT with query  (bricklen <bricklen@gmail.com>)
Re: Column names for INSERT with query  (Ian Lawrence Barwick <barwick@gmail.com>)
Re: Column names for INSERT with query  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view 
I would like to:

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

How do I correlate the names of the fields? That is, how do I indicate
which fields from r or field3 should be inserted into the right
columns in t?

pgsql-general by date:

Previous
From: Don Parris
Date:
Subject: Re: Locale Issue
Next
From: bricklen
Date:
Subject: Re: Column names for INSERT with query