Table Data can’t edit in pgAdmin 4

Known:

  • I have PostgtreSQL 12 installed
  • I have pgAdmin 4 installed
  • My Table name is table_product

Problem:

When i view table data then its displayed read only like this image below

Question:

How to make it editable … ?

Analysis:

This happen because i’m not declare a primary key

Solution:

Make one table field as primary key

Go to pgAdmin

Right click the table name -> Properties…

Change one field as primary key like image above

Press Save Button

Result:

The table now is editable like image below

Thanks for reading

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *