Hi,
attached is a patch that implements "COPY view TO" feature.
Karel
Example:
test=# CREATE VIEW vvv AS SELECT a.id, a.data AS d1, b.data AS d2 FROM
tab a, tab2 b WHERE a.id=b.fk;
CREATE VIEW
test=# COPY vvv TO '/tmp/test';
COPY
test=# \! cat /tmp/test
1 aaa AAA
2 bbb BBB
3 ccc CCC
4 ddd DDD
--
Karel Zak <zakkr@zf.jcu.cz>