Postgres Pro
Downloads
Home   >   mailing lists

Re: is there a reason we can't copy from a view? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: is there a reason we can't copy from a view?
Date
Msg-id 3724.1285275595@sss.pgh.pa.us
Whole thread Raw
In response to is there a reason we can't copy from a view?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Tree view 
Josh Berkus <josh@agliodbs.com> writes:
> ... other than it just got forgotten?

We've been over that ground before.  IIRC the conclusion was that
letting COPY TO pretend that a view is a table is a bad idea because
then people would complain about COPY FROM not working for it.  You
can useCOPY (select * from myview) TO ...
so the functionality is available.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: is there a reason we can't copy from a view?
Next
From: "David E. Wheeler"
Date:
Subject: Re: git cherry-pick timestamping issue