Skip site navigation (1) Skip section navigation (2)

COPY view

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: List pgsql-patches <pgsql-patches(at)postgreSQL(dot)org>
Cc: Hans-Jurgen Schonig <hs(at)cybertec(dot)at>
Subject: COPY view
Date: 2005-09-29 09:48:12
Message-ID: 1127987292.26535.29.camel@petra (view raw or flat)
Thread:
Lists: 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(at)zf(dot)jcu(dot)cz>

Attachment: pgsql-copyview-29092005.patch.gz
Description: application/x-gzip (4.2 KB)

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-09-29 14:26:43
Subject: Re: [PATCHES] Proposed patch for sequence-renaming problems
Previous:From: David FetterDate: 2005-09-29 08:59:35
Subject: Re: SQL/XML publishing function experimental patch II

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group