Greg Smith wrote:
>> 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 sel
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
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
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
