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)
closed as off-topic by Vince, whyzar, ArMoraer, BERA, John Powell Aug 18 '17 at 13:58
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions relating to general IT or with no clear GIS component, are off-topic here but can be researched/asked at Stack Overflow (software development), Super User (computing hardware and software), Database Administrators (relational databases) and other SE sites" – Vince, whyzar, ArMoraer, BERA, John Powell
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.