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