pgadmin-4

pgadmin 4, cannot find "edit data"

I read the Q/A "How to insert a row in postgreSQL pgAdmin?" from enter link description here , but it's for pgAdmin 3.

I just installed postgreSQL 9.6.2 with pgAdmin 4, but could not find the option shown in pgAdmin 3, which you can click to have an excel-like window where you can add and update data in a table without using SQL language (as per @KarelG). Does anyone know whether it stills exist in postgreSQL 9.6.2 with pgAdmin 4? Thanks.

Solution

  • You can select the table, use the right mouse button to select “View Data” and any of the subselections you choose.

    "View Data" in pgAdmin 4

    You can add new rows in the resulting grid.

    To save them in the database, use the “Save” icon with the image of a floppy disk:

    enter image description here