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:18:10
Message-ID: 1400bc821002011018u2738262bxda0b9bddf4f4de4b@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??

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vijay Sharma 2010-02-01 18:20:54 How Copy from a view to CSV file
Previous Message Chris Barnes 2010-02-01 18:00:19 Re: Connect to Postgres problems