| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, 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 21:11:51 |
| Message-ID: | 200606142111.k5ELBpk22349@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Andrew Dunstan wrote:
> >Right, but even when we have that, should we be able to dump a view just
> >like a real table?
> >
> >
> >
>
> Wouldn't it just be this? :
>
> COPY (SELECT * from viewname) TO ...
>
> I don't see why views should be special. Tables clearly should be
> because we can open them directly.
Ah, I didn't think of that. Good idea. So we don't need this patch?
--
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 | Tom Lane | 2006-06-14 21:12:54 | Re: [PATCH] Fix Ctrl-C related issues in psql (not for 8.1) |
| Previous Message | Andrew Dunstan | 2006-06-14 21:08:56 | Re: COPY view |