Ask a Question
Report a Bug
This page in other versions:
Warning: This documentation is for a pre-release version of 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. If the table definition does not include an OID or a primary key,
the displayed data is read only. Note that views cannot be edited; updatable
views (using rules) are not supported.
The editor features a toolbar that allows quick access to frequently used
options, and a work environment divided into two panels:
The Query Tool and View/Edit Data tools
are actually different operating modes of the same tool. Some controls will be
disabled in either mode. Please see
The Query Tool Toolbar for a description of the
The top row of the data grid displays the name of each column, the data type,
and if applicable, the number of characters allowed. A column that is part of
the primary key will additionally be marked with [PK].
To modify the displayed data:
To enter a newline character, click Ctrl-Enter or Shift-Enter. Newline
formatting is only displayed when the field content is accessed via an edit
To add a new row to the table, enter data into the last (unnumbered) row of the
table. As soon as you store the data, the row is assigned a row number, and a
fresh empty line is added to the data grid.
To write a SQL NULL to the table, simply leave the field empty. When you store
the new row, the will server fill in the default value for that column. If you
store a change to an existing row, the value NULL will explicitly be written.
To write an empty string to the table, enter the special string ‘’ (two single
quotes) in the field. If you want to write a string containing solely two single
quotes to the table, you need to escape these quotes, by typing ‘’
To delete a row, press the Delete toolbar button. A popup will open, asking
you to confirm the deletion.
To commit the changes to the server, select the Save Data toolbar button.
Geometry Data Viewer
If PostGIS is installed, you can view GIS objects in a map by selecting row(s)
and clicking the ‘View Geometry’ button in the column. If no rows are selected,
the entire data set will be rendered:
You can adjust the layout by dragging the title of the panel. To view the
properties of the geometries directly in map, just click the specific geometry:
You can access Sort/Filter options dialog by clicking on Sort/Filter button.
This allows you to specify an SQL Filter to limit the data displayed and data
sorting options in the edit grid window:
id > 25 AND created > '2018-01-01'
To add new column(s) in data sorting grid, click on the [+] icon.
To delete a row from the grid, click the trash icon.