'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

enter image description here

I want result like below which has icon of a pencil which shows that the field is editable.

enter image description here

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:

enter image description here

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