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 [ 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. +

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 55 | next ›
Discussion Overview
grouppgsql-patches @
categoriespostgresql
postedSep 29, '05 at 9:44a
activeAug 24, '06 at 6:58p
posts55
users11
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2018 Grokbase