This patch implements the COPY VIEW TODO item. Do we want to apply it for 8.2?
--------------------------------------------------------------------------- Karel Zak wrote: > > 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]> [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend