How Copy from a view to CSV file

From: Vijay Sharma <vjsharma25(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How Copy from a view to CSV file
Date: 2010-02-01 18:20:54
Message-ID: 1400bc821002011020t618a3a21k80ddfc1ff63c2996@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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??

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-02-01 18:21:19 Re: How Copy from a view to CSV file
Previous Message Vijay Sharma 2010-02-01 18:18:10 How Copy from a view to CSV file