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@xxxxxxxxxxxxxxx www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
