On PostgreSQL 11, I’ve created a new table from another, using a subquery :
CREATE TABLE table2 AS (SELECT * FROM table1)
As a result, table2 is created, but each column is in read-only mode. I suppose it’s because table2 values are linked to table1, but it’s not what I excepted : I want table2 editable and independent from table1. I can’t find a way to do it.
Can someone help me ? Thanks a lot