| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, List pgsql-patches <pgsql-patches(at)postgresql(dot)org>, Hans-Jurgen Schonig <hs(at)cybertec(dot)at> |
| Subject: | Re: COPY view |
| Date: | 2006-06-14 21:08:56 |
| Message-ID: | 44907AE8.6080109@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-06-14 21:11:51 | Re: COPY view |
| Previous Message | Bruce Momjian | 2006-06-14 20:57:42 | Re: SQL/XML publishing function experimental patch II |