On Apr 13, 2006, at 10:58 AM, Tomas Lanczos wrote:

> I am quite a newbie in the database business, so sorry for stupid
> questions.
> Is there any convenient and simple method/tool to export data from
> views to
> file, something like COPY TO (file) from a table?


One option is to create a temp table and then use COPY on the temp
table. Something like

CREATE TEMP TABLE temp_table AS SELECT * from some_view;


It would be really nice if copy worked on views directly.




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend