i exported data from a materialized view into a csv. now i’m trying to import that csv file into a new materialized view (that have the same schema) but i’m getting the error in the screen shot.
is there a way to import data from csv file into materialized view?
ERROR: cannot copy to view “gnss_port_timeline_daily”
HINT: To enable copying to a view, provide an INSTEAD OF INSERT trigger.
SQL state: 42809
we are using postragsql.