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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
