CODEWITHSUNDEEP
postgresqlpgadmin-4
Vishnu S. Divetia
Vishnu S. Divetia

Reputation: 315

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.

Upvotes: 11

Views: 16286

Answers (4)

Trinh Hieu
Trinh Hieu

Reputation: 805

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

Upvotes: 0

iRestMyCaseYourHonor
iRestMyCaseYourHonor

Reputation: 809

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

Upvotes: 0

Shahid Tariq
Shahid Tariq

Reputation: 931

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

Upvotes: 3

jjanes
jjanes

Reputation: 44227

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

Upvotes: 41

Related Questions