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