'Make column editiable in pgadmin4
How to unlock the fields in pgadmin4 so I can insert/update column directly threw pgadmin4 Data Output result. Please refer below image displaying lock icon in each field
I want result like below which has icon of a pencil which shows that the field is editable.
I have given all the permission on the table.
Solution 1:[1]
Give your table a primary key column. Otherwise, pgAdmin4 has no way to communicate to the database which row you are trying to edit.
Solution 2:[2]
We have to make sure we have selected the primary key at tables properties level (right click on your table). You can do that inside table properties column section:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | jjanes |
| Solution 2 | Shahid Tariq |



