Re: COPY view

Bruce Momjian wrote:

>Andrew Dunstan wrote:
>
>
>>Bruce Momjian wrote:
>>
>>
>>
>>>This patch implements the COPY VIEW TODO item.  Do we want to apply it
>>>for 8.2?
>>>
>>>
>>>
>>>
>>>
>>I thought the consensus was that it would be better to do
>>
>>  COPY (SELECT ...) TO ...
>>
>>rather than requiring the intermediate creation of a view.
>>
>>
>
>Right, but even when we have that, should we be able to dump a view just
>like a real table?
>
>
>

Wouldn't it just be this? :

  COPY (SELECT * from viewname) TO ...

I don't see why views should be special. Tables clearly should be
because we can open them directly.

cheers

andrew