Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot Save New Records in PgAdmin4- "SAVE" Icon Grayed Out

Tags:

pgadmin-4

I'm saving new record entries in PgAdmin4 database, but cannot saved the new records because the "SAVE" icon is grayed out. What should I do to enable the SAVE function?

I'm just learning the PostgreSQL database and PgAdmin4 on the creation of database by following a tutorial in YouTube. As a result, I'm stuck on the "saving step" and don't know what to do. I've googled out for a solution and checked a similar issue here at stack overflow, but cannot find one.

There is no coding involved in my issue.

I did not get any error messages. It's simply that the "SAVE" function is grayed out and am not able to commit my new record entries to the new database I created.

like image 648
Satoru Sotoyama Avatar asked Oct 22 '19 01:10

Satoru Sotoyama


People also ask

How do you save a record on pgAdmin?

Click the Save icon to perform a quick-save of a previously saved query, or to access the Save menu: Select Save to save the selected content of the SQL Editor panel in a file. Select Save As to open a new browser dialog and specify a new location to which to save the selected content of the SQL Editor panel.

How do you save data on pgAdmin 4?

Step 1: Visit your schema section and select the table you wish to export. Step 2: Right-click on the table name to show up the available options. Step 3: Select the “Import/Export” option. When you click on it, the export data pgAdmin window will appear.

How do you save edit rows in pgAdmin?

Use the Save icon to save your changes to the currently displayed table contents. Use options on the Find menu to access Search and Replace functionality or to Jump to another line. Click the Copy icon to copy the currently selected data. Click the Paste Row icon to paste the content that is currently on the clipboard.

How do you edit and save in pgAdmin 4?

To view or modify data, right click on a table or view name in the Browser tree control. When the context menu opens, use the View/Edit Data menu to specify the number of rows you would like to display in the editor panel. To modify the content of a table, each row in the table must be uniquely identifiable.


1 Answers

I encountered the same issue. It seems that the PgAdmin UI was changed, and now there is this "Save Data Changes" button:

Save changes button

This worked for me.

like image 177
shadowsora Avatar answered Oct 04 '22 17:10

shadowsora