Team Ai
Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face
1likes14kdownloads
editgrid.html341 linesDownload Raw Back to html
1
2
3<!DOCTYPE html>
4
5<html lang="en" data-content_root="./">
6  <head>
7    <meta charset="utf-8" />
8    <meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
9
10    <title>View/Edit Data &#8212; pgAdmin 4 8.6 documentation</title>
11    <link rel="stylesheet" type="text/css" href="_static/pygments.css?v=fa44fd50" />
12    <link rel="stylesheet" type="text/css" href="_static/style.css?v=d36593c3" />
13    
14    <script src="_static/documentation_options.js?v=d4c83366"></script>
15    <script src="_static/doctools.js?v=9a2dae69"></script>
16    <script src="_static/sphinx_highlight.js?v=dc90522c"></script>
17    
18    <script src="_static/sidebar.js"></script>
19    
20    <link rel="index" title="Index" href="genindex.html" />
21    <link rel="search" title="Search" href="search.html" />
22    <link rel="next" title="View/Edit Data Filter" href="viewdata_filter.html" />
23    <link rel="prev" title="Query Tool Toolbar" href="query_tool_toolbar.html" /> 
24  </head><body>
25    <div class="related" role="navigation" aria-label="related navigation">
26      <h3>Navigation</h3>
27      <ul>
28        <li class="right" style="margin-right: 10px">
29          <a href="genindex.html" title="General Index"
30             accesskey="I">index</a></li>
31        <li class="right" >
32          <a href="viewdata_filter.html" title="View/Edit Data Filter"
33             accesskey="N">next</a> |</li>
34        <li class="right" >
35          <a href="query_tool_toolbar.html" title="Query Tool Toolbar"
36             accesskey="P">previous</a> |</li>
37        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
38          <li class="nav-item nav-item-1"><a href="developer_tools.html" accesskey="U">Developer Tools</a> &#187;</li>
39        <li class="nav-item nav-item-this"><a href="">View/Edit Data</a></li> 
40      </ul>
41    </div>  
42
43    <div class="document">
44      <div class="documentwrapper">
45        <div class="bodywrapper">
46          <div class="body" role="main">
47            
48  <section id="view-edit-data">
49<span id="editgrid"></span><h1><span class="target" id="index-0"></span>View/Edit Data<a class="headerlink" href="#view-edit-data" title="Link to this heading">¶</a></h1>
50<p>To view or modify data, right click on a table or view name in the
51<em>Object Explorer</em>. When the context menu opens, use the <em>View/Edit Data</em> menu
52to specify the number of rows you would like to display in the editor panel.</p>
53<img alt="Edit grid window" class="align-center" src="_images/editgrid.png" />
54<p>To modify the content of a table, each row in the table must be uniquely
55identifiable. If the table definition does not include an OID or a primary key,
56the displayed data is read only. Note that views cannot be edited; updatable
57views (using rules) are not supported.</p>
58<p>The editor features a toolbar that allows quick access to frequently used
59options, and a work environment divided into two panels:</p>
60<ul class="simple">
61<li><p>The upper panel displays the SQL command that was used to select the content
62displayed in the lower panel.</p></li>
63<li><p>The lower panel (the Data Grid) displays the data selected from the table or
64view.</p></li>
65</ul>
66<section id="the-view-edit-data-toolbar">
67<h2>The View/Edit Data Toolbar<a class="headerlink" href="#the-view-edit-data-toolbar" title="Link to this heading">¶</a></h2>
68<p>The <a class="reference internal" href="query_tool.html#query-tool"><span class="std std-ref">Query Tool</span></a> and <a class="reference internal" href="#editgrid"><span class="std std-ref">View/Edit Data</span></a> tools
69are actually different operating modes of the same tool. Some controls will be
70disabled in either mode. Please see
71<a class="reference internal" href="query_tool_toolbar.html#query-tool-toolbar"><span class="std std-ref">The Query Tool Toolbar</span></a> for a description of the
72available controls.</p>
73</section>
74<section id="the-data-grid">
75<span id="data-grid"></span><h2>The Data Grid<a class="headerlink" href="#the-data-grid" title="Link to this heading">¶</a></h2>
76<p>The top row of the data grid displays the name of each column, the data type,
77and if applicable, the number of characters allowed. A column that is part of
78the primary key will additionally be marked with [PK].</p>
79<p>To modify the displayed data:</p>
80<ul class="simple">
81<li><p>To change a numeric value within the grid, double-click the value to select
82the field.  Modify the content in the square in which it is displayed.</p></li>
83<li><p>To change a non-numeric value within the grid, double-click the content to
84access the edit bubble.  After modifying the contentof the edit bubble, click
85the <em>Ok</em> button to display your changes in the data grid, or <em>Cancel</em> to
86exit the edit bubble without saving.</p></li>
87</ul>
88<p>To enter a newline character, click Ctrl-Enter or Shift-Enter.  Newline
89formatting is only displayed when the field content is accessed via an edit
90bubble.</p>
91<p>To add a new row to the table, enter data into the last (unnumbered) row of the
92table. As soon as you store the data, the row is assigned a row number, and a
93fresh empty line is added to the data grid.</p>
94<p>To write a SQL NULL to the table, simply leave the field empty. When you store
95the new row, the will server fill in the default value for that column. If you
96store a change to an existing row, the value NULL will explicitly be written.</p>
97<p>To write an empty string to the table, enter the special string ‘’ (two single
98quotes) in the field. If you want to write a string containing solely two single
99quotes to the table, you need to escape these quotes, by typing ''</p>
100<p>To delete a row, press the <em>Delete</em> toolbar button.  A popup will open, asking
101you to confirm the deletion.</p>
102<p>To commit the changes to the server, select the <em>Save Data</em> toolbar button.</p>
103<p><strong>Geometry Data Viewer</strong></p>
104<p>If PostGIS is installed, you can view GIS objects in a map by selecting row(s)
105and clicking the ‘View Geometry’ button in the column. If no rows are selected,
106the entire data set will be rendered:</p>
107<img alt="Geometry Viewer Button" class="align-center" src="_images/geometry_viewer.png" />
108<p>You can adjust the layout by dragging the title of the panel. To view the
109properties of the geometries directly in map, just click the specific geometry:</p>
110<img alt="Geometry Viewer Property Table" class="align-center" src="_images/geometry_viewer_property_table.png" />
111<div class="admonition note">
112<p class="admonition-title">Note</p>
113<ul class="simple">
114<li><p><em>Supported data types:</em> The Geometry Viewer supports 2D and 3DM geometries in
115EWKB format including <cite>Point, LineString, Polygon MultiPoint, MultiLineString,
116MultiPolygon and GeometryCollection</cite>.</p></li>
117<li><p><em>SRIDs:</em> If there are geometries with different SRIDs in the same column, the
118viewer will render geometries with the same SRID in the map. If SRID=4326 the
119OSM tile layer will be added into the map.</p></li>
120<li><p><em>Data size:</em> For performance reasons, the viewer will render no more than
121100000 geometries, totaling up to 20MB.</p></li>
122<li><p><em>Internet access:</em> An internet connection is required for the Geometry Viewer
123to function correctly.</p></li>
124</ul>
125</div>
126<p><strong>JSON Data Editor</strong></p>
127<p>A built in json editor is provided for <em>JSON/JSONB Data</em>.Double clicking on json/jsonb
128data type cell in data grid will open JSON Editor.Editor provides different mode to
129view and edit json data.</p>
130<img alt="Json Editor" class="align-center" src="_images/json_editor_modes.png" />
131<p><em>Code Mode</em>:
132Provides way to format &amp; compact json data.Also provides ability to repair json data
133by fixing quotes and escape characters, removing comments and JSONP notation and
134turn JavaScript objects into JSON.</p>
135<p><em>Tree Mode</em>:
136Enabled to change, add, move, remove, and duplicate fields and values.Provides ability
137to searh &amp; hilight data.</p>
138<p><em>Form Mode</em>:
139Allows only to edit values in json data there by providing ability to keep data structure
140unchanged while editing.</p>
141<p><em>Preview Mode</em>:
142Provides ability to check data before saving and also shows size of current json data.
143Format and compact json data as well.</p>
144<p><em>Editor Toolbar</em></p>
145<p>Different options are provided to manipulate json data.</p>
146<p>Code/Preview mode:</p>
147<img alt="Json Editor Code/Preview mode Tool Bar" class="align-center" src="_images/json_editor_code_preview_tool_bar.png" />
148<p>Tree/Form mode:</p>
149<img alt="Json Editor Tree/Form mode Tool Bar" class="align-center" src="_images/json_editor_tree_form_mode_tool_bar.png" />
150<table class="longtable docutils align-default">
151<colgroup>
152<col style="width: 16.7%" />
153<col style="width: 50.0%" />
154<col style="width: 33.3%" />
155</colgroup>
156<thead>
157<tr class="row-odd"><th class="head"><p>Icon</p></th>
158<th class="head"><p>Behavior</p></th>
159<th class="head"><p>Available in mode</p></th>
160</tr>
161</thead>
162<tbody>
163<tr class="row-even"><td><p><em>Format Json</em></p></td>
164<td><p>Click to <em>Format Json</em> format json data with proper indentation.</p></td>
165<td><p>Code, Preview</p></td>
166</tr>
167<tr class="row-odd"><td><p><em>Compact Json</em></p></td>
168<td><p>Click to <em>Compact Json</em> get compacted json data.</p></td>
169<td><p>Code, Preview</p></td>
170</tr>
171<tr class="row-even"><td><p><em>Sort</em></p></td>
172<td><p>Click to <em>Sort</em> icon to set sorting criteria for the data using file values.</p></td>
173<td><p>Code, Preview, Tree</p></td>
174</tr>
175<tr class="row-odd"><td><p><em>Transform</em></p></td>
176<td><p>Click to <em>Transform</em>  to filter data  using JSME query language.</p></td>
177<td><p>Code, Preview, Tree</p></td>
178</tr>
179<tr class="row-even"><td><p><em>Undo</em></p></td>
180<td><p>Click to <em>Undo</em> to undo last action performed on data .</p></td>
181<td><p>Code, Preview, Tree, From</p></td>
182</tr>
183<tr class="row-odd"><td><p><em>Redo</em></p></td>
184<td><p>Click to <em>Redo</em> to repat last action performed on data .</p></td>
185<td><p>Code, Preview, Tree, From</p></td>
186</tr>
187<tr class="row-even"><td><p><em>Mode</em></p></td>
188<td><p>Click to <em>Mode</em> dropdown to change dipaly mode of editor.Different modes avaialble
189are Code, Preview, Tree, From.</p></td>
190<td><p>Code, Tree, From, Preview</p></td>
191</tr>
192<tr class="row-odd"><td><p><em>Expand All</em></p></td>
193<td><p>Click to <em>Expand All</em> to expand json data.</p></td>
194<td><p>Tree, From</p></td>
195</tr>
196<tr class="row-even"><td><p><em>Collapse All</em></p></td>
197<td><p>Click to <em>Redo</em> to collapse json data.</p></td>
198<td><p>Tree, From</p></td>
199</tr>
200<tr class="row-odd"><td><p><em>Search Box</em></p></td>
201<td><p>Enter partial/complete string to search in data.</p></td>
202<td><p>Tree, From</p></td>
203</tr>
204</tbody>
205</table>
206</section>
207<section id="sort-filter-options-dialog">
208<h2>Sort/Filter options dialog<a class="headerlink" href="#sort-filter-options-dialog" title="Link to this heading">¶</a></h2>
209<p>You can access <em>Sort/Filter options dialog</em> by clicking on Sort/Filter button.
210This allows you to specify an SQL Filter to limit the data displayed and data
211sorting options in the edit grid window:</p>
212<img alt="Edit grid filter dialog window" class="align-center" src="_images/editgrid_filter_dialog.png" />
213<ul class="simple">
214<li><p>Use <em>SQL Filter</em> to provide SQL filtering criteria. These will be added to
215the “WHERE” clause of the query used to retrieve the data. For example,
216you might enter:</p></li>
217</ul>
218<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">id</span><span class="w"> </span><span class="o">&gt;</span><span class="w"> </span><span class="mi">25</span><span class="w"> </span><span class="k">AND</span><span class="w"> </span><span class="n">created</span><span class="w"> </span><span class="o">&gt;</span><span class="w"> </span><span class="s1">&#39;2018-01-01&#39;</span>
219</pre></div>
220</div>
221<ul class="simple">
222<li><p>Use <em>Data Sorting</em> to sort the data in the output grid</p></li>
223</ul>
224<p>To add new column(s) in data sorting grid, click on the [+] icon.</p>
225<ul class="simple">
226<li><p>Use the drop-down <em>Column</em> to select the column you want to sort.</p></li>
227<li><p>Use the drop-down <em>Order</em> to select the sort order for the column.</p></li>
228</ul>
229<p>To delete a row from the grid, click the trash icon.</p>
230<ul class="simple">
231<li><p>Click the <em>Save</em> button to save work.</p></li>
232<li><p>Click the <em>Close</em> button to discard current changes and close the dialog.</p></li>
233</ul>
234<div class="toctree-wrapper compound">
235<ul>
236<li class="toctree-l1"><a class="reference internal" href="viewdata_filter.html">View/Edit Data Filter</a></li>
237</ul>
238</div>
239</section>
240<section id="promote-view-edit-data-to-query-tool">
241<h2>Promote View/Edit Data to Query Tool<a class="headerlink" href="#promote-view-edit-data-to-query-tool" title="Link to this heading">¶</a></h2>
242<p>A View/Edit Data tab can be converted to a Query Tool Tab just by editing the query. Once you start editing, it will ask if you really want to move away from View/Edit.</p>
243<img alt="Promote View/Edit Data tab to Query Tool tab warning" class="align-center" src="_images/promote_view_edit_data_warning.png" />
244<p>You can disable the dialog by selecting the “Don’t Ask again” checkbox. If you wish to resume the confirmation dialog, you can do it from “Prefrences -&gt; Query Tool -&gt; Editor -&gt; Show View/Edit Data Promotion Warning?”</p>
245<p>Once you chose to continue, you won’t be able to use the features of View/Edit mode like the filter and sorting options, limit, etc. It is a one-way conversion. It will be a query tool now.</p>
246</section>
247</section>
248
249
250            <div class="clearer"></div>
251          </div>
252        </div>
253      </div>
254      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
255        <div class="sphinxsidebarwrapper">
256  <div>
257    <h3><a href="index.html">Table of Contents</a></h3>
258    <ul>
259<li><a class="reference internal" href="#">View/Edit Data</a><ul>
260<li><a class="reference internal" href="#the-view-edit-data-toolbar">The View/Edit Data Toolbar</a></li>
261<li><a class="reference internal" href="#the-data-grid">The Data Grid</a></li>
262<li><a class="reference internal" href="#sort-filter-options-dialog">Sort/Filter options dialog</a></li>
263<li><a class="reference internal" href="#promote-view-edit-data-to-query-tool">Promote View/Edit Data to Query Tool</a></li>
264</ul>
265</li>
266</ul>
267
268  </div>
269<h3><a href="index.html">Table of Contents</a></h3>
270<ul class="current">
271<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
272<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
273<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
274<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
275<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
276<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
277<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
278<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
279<li class="toctree-l1 current"><a class="reference internal" href="developer_tools.html">Developer Tools</a><ul class="current">
280<li class="toctree-l2"><a class="reference internal" href="debugger.html">Debugger</a></li>
281<li class="toctree-l2"><a class="reference internal" href="query_tool.html">Query Tool</a></li>
282<li class="toctree-l2 current"><a class="current reference internal" href="#">View/Edit Data</a></li>
283<li class="toctree-l2"><a class="reference internal" href="schema_diff.html">Schema Diff</a></li>
284<li class="toctree-l2"><a class="reference internal" href="erd_tool.html">ERD Tool</a></li>
285<li class="toctree-l2"><a class="reference internal" href="psql_tool.html">PSQL Tool</a></li>
286</ul>
287</li>
288<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
289<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
290<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
291<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
292<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
293</ul>
294
295<search id="searchbox" style="display: none" role="search">
296  <h3 id="searchlabel">Quick search</h3>
297    <div class="searchformwrapper">
298    <form class="search" action="search.html" method="get">
299      <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
300      <input type="submit" value="Go" />
301    </form>
302    </div>
303</search>
304<script>document.getElementById('searchbox').style.display = "block"</script>
305        </div>
306<div id="sidebarbutton" title="Collapse sidebar">
307<span>«</span>
308</div>
309
310      </div>
311      <div class="clearer"></div>
312    </div>
313    <div class="related" role="navigation" aria-label="related navigation">
314      <h3>Navigation</h3>
315      <ul>
316        <li class="right" style="margin-right: 10px">
317          <a href="genindex.html" title="General Index"
318             >index</a></li>
319        <li class="right" >
320          <a href="viewdata_filter.html" title="View/Edit Data Filter"
321             >next</a> |</li>
322        <li class="right" >
323          <a href="query_tool_toolbar.html" title="Query Tool Toolbar"
324             >previous</a> |</li>
325        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
326          <li class="nav-item nav-item-1"><a href="developer_tools.html" >Developer Tools</a> &#187;</li>
327        <li class="nav-item nav-item-this"><a href="">View/Edit Data</a></li> 
328      </ul>
329    </div>
330    <div class="footer" role="contentinfo">
331        <div class="related" role="navigation" aria-label="related navigation">
332          <ul>
333              <li class="left" style="margin-left: 10px">&#169; Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
334            <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
335            <li class="right" ><a href="viewdata_filter.html" title="View/Edit Data Filter" accesskey="N">next</a> |</li>
336            <li class="right" ><a href="query_tool_toolbar.html" title="Query Tool Toolbar" accesskey="P">previous</a> |</li>
337          </ul>
338        </div>
339    </div>
340  </body>
341</html>
codekingpro/portable-devtools · Team Ai