Opening a View
Views in PostgreSQL databases cannot be edited because the views do not have primary keys.
- On the top menu bar, choose Database Management. On the displayed Objects tab, choose Views on the left, locate the target view, and click Open in the Operation column.Figure 1 Opening a view
- On the displayed page, check the view details directly or using Where Condition.Figure 2 Obtaining view details
Table 1 Functions
Copies data of the selected row. Specifically, double-click the target row and then click Copy Row.
Allows you to copy all data in a column by selecting this column from the Copy Column drop-down list.
Allows you to set the columns you want to display.
Allows you to update table data manually.
Shows the detailed information of a specified row.