Menu
Something strange is happening with my new created tables in Postgres, I can add data to them, but I cannot use PgAdmin to edit the any row.
This is my table columns description:
After executing the query to view all table rows this is what I can see:
Save button is disabled to update my table rows. But this is happening only with my new created tables, as you can see, I have other tables where I'm able to edit rows, for example at this table of Users:
904
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.
Select column, right click and choose Properties... option to open column editor. Alternatively select column in tree control and on Properties tab and open column editor with edit icon. In the editor update Comment field and confirm changes with Save button.
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.
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.
Found the problem! That was happening, because I didn't select any of the columns as 'Primary key':
198
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
