From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
Cc: | List pgsql-patches <pgsql-patches(at)postgresql(dot)org>, Hans-Jurgen Schonig <hs(at)cybertec(dot)at> |
Subject: | Re: COPY view |
Date: | 2006-06-14 20:44:38 |
Message-ID: | 200606142044.k5EKicU16900@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
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 <zakkr(at)zf(dot)jcu(dot)cz>
[ 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. +
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2006-06-14 20:50:30 | Re: COPY view |
Previous Message | Martijn van Oosterhout | 2006-06-14 20:32:41 | Re: [PATCH] Fix Ctrl-C related issues in psql (not for 8.1) |