Re: COPY (query) TO file - Mailing list pgsql-hackers

From Greg Stark
Subject Re: COPY (query) TO file
Date
Msg-id 87lksecken.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: COPY (query) TO file  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: COPY (query) TO file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Supporting VALUES only in INSERT would be relatively trivial BTW,
> but the spec actually thinks it should be allowed as a <table spec>
> in FROM ...

How does that syntax work?

INSERT INTO x (a,b) from select x,y,z from t from select x2,y2,z2 from t

? doesn't seem to be very sensible?


-- 
greg



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: More thoughts about planner's cost estimates
Next
From: Andrew Dunstan
Date:
Subject: Re: 'CVS-Unknown' buildfarm failures?