Re: is there a reason we can't copy from a view?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: is there a reason we can't copy from a view?
Date: 2010-09-23 20:59:55
Message-ID: 3724.1285275595@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)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 use
COPY (select * from myview) TO ...
so the functionality is available.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2010-09-23 21:20:07 Re: git cherry-pick timestamping issue
Previous Message Josh Berkus 2010-09-23 20:52:36 is there a reason we can't copy from a view?