Re: How Copy from a view to CSV file

Vijay Sharma wrote:
> I want to copy view's data into a .CSV file. But postgresql is
> generating an error as
> ERROR: cannot copy from view 'myview'
>
> I am executing the command
>
> COPY temp_error_view TO '/tmp/tempError.csv' USING DELIMITERS ','
> WITH CSV ;
>
> I think postgresql doesn't allow to copy from view to csv directly. Do
> i have to create a temp table from the view and then copy that data to
> the csv file??

Right, you can only COPY directly from a table, not a view. But you can
copy out anything you can select, so this should work:

COPY (SELECT * FROM temp_error_view) TO '/tmp/tempError.csv' USING
DELIMITERS ',' WITH CSV ;

--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com