Search Postgresql Archives
How Copy from a view to CSV file
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
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??
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]