In PostgreSQL, when you encounter an error like ERROR: permission denied for ~, it means you don’t have permissions for the table, so you need to check this.

Error Details

ERROR:  permission denied for table table_name

Command to Check Permissions

\\z

Query to Grant Table Permissions

GRANT SELECT, UPDATE, INSERT ON table_name TO role_name;

That’s all from the Gemba.