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)

enter image description here

  • 1
    If you want to do a query you need to select the database, then under tools -> Query tools and typ in your query. The queries from View/edit data are uneditable. You can only edit the data itself – LaughU Aug 18 '17 at 10:45
  • 1
    besides your question does not seem to have a spatial component and therefore is offtopic here. Rather try and ask it at Database SE – LaughU Aug 18 '17 at 10:50

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.

  • Thanks for your answer. I was aware of that Query tool. I just would like to edit the data directly in the table in a subselection and not going through the whole table. And I thought this would be possible in the Edit Data view. – JoeBe Aug 18 '17 at 13:16
  • Yeah, it's very strange that it doesn't just let you edit the query. – Stephen Apr 20 '19 at 23:49

Not the answer you're looking for? Browse other questions tagged or ask your own question.