Menu
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.
459
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.
Expand your table properties by clicking on it in the pgAdmin4 legend. Right-click on 'Constraints', select 'Create' --> 'Primary Key'to define a primary key column. On the Data Output tab at the bottom of the table below the last row, there will be an empty row where you can enter new data in an excel-like manner.
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.
To edit table comment in Properties tab click edit icon to open table editor. or right click table and choose Properties... option. In table editor update Comment field and confirm with Save button.
After editing the data, simple click on Save Data Changes (F6) icon.
170
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
