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 <[EMAIL PROTECTED]>
pgsql-copyview-29092005.patch.gz
Description: GNU Zip compressed data
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend