COPY view - Mailing list pgsql-patches

From Karel Zak
Subject COPY view
Date
Msg-id 1127987292.26535.29.camel@petra
Whole thread Raw
Responses Re: COPY view
Re: COPY view
Re: COPY view
List pgsql-patches
 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>

Attachment

pgsql-patches by date:

Previous
From: David Fetter
Date:
Subject: Re: SQL/XML publishing function experimental patch II
Next
From: Michael Fuhr
Date:
Subject: fuzzystrmatch URL, spelling corrections