B
B
barakuda12022-04-01 14:38:22
PostgreSQL
barakuda1, 2022-04-01 14:38:22

How to remove readonly in Postgresql?

6246e3fa3bcbc556743006.png

Made a duplicate table using the

CREATE TABLE table_name AS (SELECT * FROM table_name2) command;

And now I can’t edit, it costs readonly, nothing helps.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2022-04-01
@melkij

Postgresql does not prevent you from editing. Since you were able to create a table, it means that the database is not in read only mode. Write an appropriate update and execute.
But your GUI client most likely does not like the lack of a primary key.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question