Make column editiable in pgadmin4

Question

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.

score 36 · Accepted Answer · answered Jan 28 '20 at 17:06

36

Give your table a primary key column. Otherwise, pgAdmin4 has no way to communicate to the database which row you are trying to edit.

answered Jan 28 '20 at 17:06

jjanes

37,812
5
27
34

4

I've done this, but the locks are still there @jjanes – Nathaniel Babalola Feb 05 '21 at 17:49
1

Refresh your table to get the updated table information. – Ranjeet Ranjan Dec 21 '22 at 20:59

score 2 · Answer 2 · answered Mar 24 '22 at 10:43

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:

answered Mar 24 '22 at 10:43

Shahid Tariq

886
6
19

score 0 · Answer 3 · answered Jul 04 '23 at 10:02

The reason your table columns have a black key icon is because the id column is not a primary key, maybe because you accidentally deleted it. I encountered that in hasura when I accidentally deleted the primary key id, after resetting it. went back to normal in postgres. You also just need to reset id as primary key in postgres

score -1 · Answer 4 · answered Jul 07 '22 at 08:06

-1

It happens if I do a join with me, try seperately running the queries without joins for the columns that you want to edit.

answered Jul 07 '22 at 08:06

iRestMyCaseYourHonor

543
2
7
21

Make column editiable in pgadmin4

4 Answers4