Copy *.csv file to view in PostgreSQL

Question

I want to import data from *.csv file to view in the PostgreSQL with 9.3 version. Here is the following script I have tried.

Example:

\copy "viewName" from 'D:\filename.csv' DELIMITER ';' CSV HEADER;

Error

ERROR:  cannot copy to view "viewName"

Questions:

IMO COPY aTable FROM D:\filename.csv' DELIMITER ';' CSV HEADER; and then CREATE OR REPLACE VIEW viewName AS (SELECT * FROM aTable ) — wingedpanther, Aug 7 '14 at 11:43

Karl Bartel · Accepted Answer · 2014-08-07 11:40:47Z

COPY can only be used with plain tables, not with views. However, you can write COPY (SELECT * FROM viewname) TO ....

Since COPY is the basis for \copy, you might want to try your code with a table instead of a view and the select from there.

1 Answer 1