pgadmin 4, cannot find "edit data"

Question

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.

score 59 · Answer 1 · answered Mar 08 '20 at 20:17

59

After editing the data, simple click on Save Data Changes (F6) icon.

answered Mar 08 '20 at 20:17

nmkyuppie

1,456
1
14
30

14

I would suggest changing the icon, this one did not mean "save" action to me. – Antipod May 01 '20 at 16:09
1

Ofcourse! but may be the intention is to persist the data into cells. – nmkyuppie Jun 09 '20 at 15:35
9

Most poorly chosen icon in software history – franDayz Jul 08 '20 at 07:57
3

Perfect example for a poorly designed UI. – Krishnadas PC Oct 05 '20 at 09:04
1

Even the new icon in 5.2 is hard to recognize! – Suraj Jun 01 '21 at 14:21

score 10 · Accepted Answer · answered May 10 '17 at 08:33

10

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

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:

answered May 10 '17 at 08:33

Laurenz Albe

209,280
17
206
263

5

The save button doesn't do anything for me... just fails silently (as of pgAdmin4 version 2.0). – Troy Oct 26 '17 at 17:43
@Troy It fails silently for me too. How did you manage to save ? – Saurabh Tiwari Sep 18 '19 at 13:10
Could it be that you are lacking permissions on the table? – Laurenz Albe Sep 19 '19 at 05:48

score 5 · Answer 3 · answered Nov 28 '20 at 15:20

5

The table needs to have a primary key to become editable in pgadmin so that the column names have a pencil icon next to them instead of a padlock.

answered Nov 28 '20 at 15:20

Maciek Binder

81
1
3

score 4 · Answer 4 · answered Oct 22 '19 at 20:07

4

You can right-click the table, then select View-Edit Data, and select Filtered Rows, Edit the rows and simply close on the X in the upper right. It will ask you if you want to SAVE.

answered Oct 22 '19 at 20:07

Brian Gomez

41
1

1

It's silly, but since the Save button doesn't work the way it's supposed to, it was the only way. – Noumenon Nov 29 '19 at 05:26
P.S. You don't need to use Filtered Rows, a r.click on the table, then 'View/Edit Data' > 'All Rows' will also work. The idea seems that save/cancel works locally on each cell but nothing is truly saved yet. Then to save all your work finally, you close the currently active panel tab by hitting X in the upper right. This closes the panel tab that was created by issuing the 'View/Edit Data' > 'All Rows' in the first place. The act of closing the panel asks you if you want to save. Ideally the save button should be active and do all this, but its wrongly dimmed. – abulka Jan 17 '20 at 01:30

score 1 · Answer 5 · answered May 28 '19 at 21:23

I had some trouble finding this too, but found it eventually: Right-click the table, then select "View/Edit Data", and select "Filtered Rows", then enter the condition (format: field name = ). Now it will only be showing the row you want to find and edit, and you can double-click the value, change it, then click the save-icon button to save it.

score 1 · Answer 6 · edited Feb 12 '22 at 07:56

1

I had the same trouble. Trying to find out some short keys, I found using F6 key pretty useful.
Query tool -> F5
It will run the current query in the query editor.
Query tool -> Edit some cells -> F6
It will save the current changes to the database.
Check the query history to confirm what happend exactly.

edited Feb 12 '22 at 07:56

Dharman

30,962
25
85
135

answered Feb 12 '22 at 07:51

crazyoptimist

125
1
14

pgadmin 4, cannot find "edit data"

6 Answers6