Re: COPY view

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

In response to

  • COPY view at 2005-09-29 09:48:12 from Karel Zak

Responses

Browse pgsql-patches by date

  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)