I want to make a SELECT statement in the "View/Edit Data" mode in pgAdmin 4 but the query field is disabled. How can I enable it? (I have all privileges for all, the database, schema and table and I am the owner of all as well)
This happens when you view a specific number of records from your table by right clicking on it and pgAdmin4 allows you to only view the records and does not allow you to edit the query. The Query that you are viewing is simply the number selected that you specify.
If you want to edit the query, simply click you the table and then from Tools in the menu bar click on the Query Tool that will allow you to make edition to the query.
I hope it helps you to understand why, it can't be edited.