Re: COPY view
От | Bruce Momjian |
---|---|
Тема | Re: COPY view |
Дата | |
Msg-id | 200606142044.k5EKicU16900@candle.pha.pa.us обсуждение исходный текст |
Ответ на | COPY view (Karel Zak <zakkr@zf.jcu.cz>) |
Ответы |
Re: COPY view
|
Список | 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@zf.jcu.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. +
В списке pgsql-patches по дате отправления: