codekingpro/portable-devtools
114k
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>Menu Bar — 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="Toolbar" href="toolbar.html" />
23 <link rel="prev" title="User Interface" href="user_interface.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="toolbar.html" title="Toolbar"
33 accesskey="N">next</a> |</li>
34 <li class="right" >
35 <a href="user_interface.html" title="User Interface"
36 accesskey="P">previous</a> |</li>
37 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
38 <li class="nav-item nav-item-1"><a href="getting_started.html" accesskey="U">Getting Started</a> »</li>
39 <li class="nav-item nav-item-this"><a href="">Menu Bar</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="menu-bar">
49<span id="id1"></span><h1><span class="target" id="index-0"></span>Menu Bar<a class="headerlink" href="#menu-bar" title="Link to this heading">¶</a></h1>
50<p>The pgAdmin menu bar provides drop-down menus for access to options, commands,
51and utilities. The menu bar displays the following selections: <em>File</em>, <em>Object</em>,
52Tools*, and <em>Help</em>. Selections may be grayed out which indicates they are
53disabled for the object currently selected in the <em>pgAdmin</em> tree control.</p>
54<section id="the-file-menu">
55<h2>The File Menu<a class="headerlink" href="#the-file-menu" title="Link to this heading">¶</a></h2>
56<img alt="pgAdmin file menu bar" class="align-center" src="_images/file_menu.png" />
57<p>Use the <em>File</em> menu to access the following options:</p>
58<table class="docutils align-default">
59<thead>
60<tr class="row-odd"><th class="head"><p>Option</p></th>
61<th class="head"><p>Action</p></th>
62</tr>
63</thead>
64<tbody>
65<tr class="row-even"><td><p><em>Preferences</em></p></td>
66<td><p>Click to open the <a class="reference internal" href="preferences.html#preferences"><span class="std std-ref">Preferences</span></a> dialog to customize your pgAdmin settings.</p></td>
67</tr>
68<tr class="row-odd"><td><p><em>Reset Layout</em></p></td>
69<td><p>If you have modified the workspace, click to restore the default layout.</p></td>
70</tr>
71<tr class="row-even"><td><p><em>Runtime</em></p></td>
72<td><p>Click to open a submenu to Configure, View Log and Zoom settings. Only visible when pgAdmin4 runs in
73desktop mode. To know more about runtime menu <a class="reference internal" href="desktop_deployment.html#desktop-deployment"><span class="std std-ref">click here</span></a></p></td>
74</tr>
75</tbody>
76</table>
77</section>
78<section id="the-object-menu">
79<h2>The Object Menu<a class="headerlink" href="#the-object-menu" title="Link to this heading">¶</a></h2>
80<img alt="pgAdmin object menu bar" class="align-center" src="_images/object_menu.png" />
81<p>The <em>Object</em> menu is context-sensitive. Use the <em>Object</em> menu to access the
82following options (in alphabetical order):</p>
83<table class="docutils align-default">
84<thead>
85<tr class="row-odd"><th class="head"><p>Option</p></th>
86<th class="head"><p>Action</p></th>
87</tr>
88</thead>
89<tbody>
90<tr class="row-even"><td><p><em>Register</em></p>
91<blockquote>
92<div><ol class="arabic simple">
93<li><p><em>Server</em></p></li>
94<li><p><em>Deploy Cloud Instance</em></p></li>
95</ol>
96</div></blockquote>
97</td>
98<td><p>Click to open the <a class="reference internal" href="server_dialog.html#server-dialog"><span class="std std-ref">Server</span></a> dialog to register a server.</p>
99<p>Click to open the <a class="reference internal" href="cloud_deployment.html#cloud-deployment"><span class="std std-ref">Cloud Deployment</span></a> dialog to deploy an cloud instance.</p>
100</td>
101</tr>
102<tr class="row-odd"><td><p><em>Change Password…</em></p></td>
103<td><p>Click to open the <a class="reference internal" href="change_password_dialog.html#change-password-dialog"><span class="std std-ref">Change Password…</span></a> dialog to change your password.</p></td>
104</tr>
105<tr class="row-even"><td><p><em>Clear Saved Password</em></p></td>
106<td><p>If you have saved the database server password, click to clear the saved password.
107Enable only when password is already saved.</p></td>
108</tr>
109<tr class="row-odd"><td><p><em>Clear SSH Tunnel Password</em></p></td>
110<td><p>If you have saved the ssh tunnel password, click to clear the saved password.
111Enable only when password is already saved.</p></td>
112</tr>
113<tr class="row-even"><td><p><em>Connect Server</em></p></td>
114<td><p>Click to open the <a class="reference internal" href="connect_to_server.html#connect-to-server"><span class="std std-ref">Connect to Server</span></a> dialog to establish a connection with a server.</p></td>
115</tr>
116<tr class="row-odd"><td><p><em>Copy Server…</em></p></td>
117<td><p>Click to copy the currently selected server.</p></td>
118</tr>
119<tr class="row-even"><td><p><em>Create</em></p></td>
120<td><p>Click <em>Create</em> to access a context menu that provides context-sensitive selections.
121Your selection opens a <em>Create</em> dialog for creating a new object.</p></td>
122</tr>
123<tr class="row-odd"><td><p><em>Delete</em></p></td>
124<td><p>Click to delete the currently selected object from the server.</p></td>
125</tr>
126<tr class="row-even"><td><p><em>Delete (Cascade)</em></p></td>
127<td><p>Click to delete the currently selected object and all dependent objects from the server.</p></td>
128</tr>
129<tr class="row-odd"><td><p><em>Delete (Force)</em></p></td>
130<td><p>Click to delete the currently selected database with force option.</p></td>
131</tr>
132<tr class="row-even"><td><p><em>Disconnect from server</em></p></td>
133<td><p>Click to disconnect from the currently selected server.</p></td>
134</tr>
135<tr class="row-odd"><td><p><em>Properties…</em></p></td>
136<td><p>Click to review or modify the currently selected object’s properties.</p></td>
137</tr>
138<tr class="row-even"><td><p><em>Refresh</em></p></td>
139<td><p>Click to refresh the currently selected object.</p></td>
140</tr>
141<tr class="row-odd"><td><p><em>Remove Server</em></p></td>
142<td><p>Click to remove the currently selected server.</p></td>
143</tr>
144<tr class="row-even"><td><p><em>Scripts</em></p></td>
145<td><p>Click to open the <a class="reference internal" href="query_tool.html#query-tool"><span class="std std-ref">Query tool</span></a> to edit or view the selected script from the flyout menu.</p></td>
146</tr>
147<tr class="row-odd"><td><p><em>Trigger(s)</em></p></td>
148<td><p>Click to <em>Disable</em> or <em>Enable</em> trigger(s) for the currently selected table. Options are displayed on the flyout menu.</p></td>
149</tr>
150<tr class="row-even"><td><p><em>Truncate</em></p></td>
151<td><p>Click to remove all rows from a table (<em>Truncate</em>), to remove all rows from a table and its child tables
152(<em>Truncate Cascade</em>) or to remove all rows from a table and automatically restart sequences owned by columns
153(<em>Truncate Restart Identity</em>). Options are displayed on the flyout menu.</p></td>
154</tr>
155<tr class="row-odd"><td><p><em>View Data</em></p></td>
156<td><p>Click to access a context menu that provides several options for viewing data (see below).</p></td>
157</tr>
158<tr class="row-even"><td><p><em>ERD For Database</em></p></td>
159<td><p>Click to open the ERD tool with automatically generated diagram for the database selected.
160This option is available only when a database is selected. Options are displayed on the flyout menu.</p></td>
161</tr>
162<tr class="row-odd"><td><p><em>ERD For Table</em></p></td>
163<td><p>Click to open the ERD tool with automatically generated diagram for the table selected.
164This option is available only when a table is selected. Options are displayed on the flyout menu.</p></td>
165</tr>
166</tbody>
167</table>
168</section>
169<section id="the-tools-menu">
170<h2>The Tools Menu<a class="headerlink" href="#the-tools-menu" title="Link to this heading">¶</a></h2>
171<img alt="pgAdmin tools menu bar" class="align-center" src="_images/tool_menu.png" />
172<p>Use the <em>Tools</em> menu to access the following options (in alphabetical order):</p>
173<table class="docutils align-default">
174<thead>
175<tr class="row-odd"><th class="head"><p>Option</p></th>
176<th class="head"><p>Action</p></th>
177</tr>
178</thead>
179<tbody>
180<tr class="row-even"><td><p><em>ERD Tool</em></p></td>
181<td><p>Click to open the <a class="reference internal" href="erd_tool.html#erd-tool"><span class="std std-ref">ERD Tool</span></a> and start designing your database.</p></td>
182</tr>
183<tr class="row-odd"><td><p><em>Grant Wizard…</em></p></td>
184<td><p>Click to access the <a class="reference internal" href="grant_wizard.html#grant-wizard"><span class="std std-ref">Grant Wizard</span></a> tool.</p></td>
185</tr>
186<tr class="row-even"><td><p><em>PSQL Tool</em></p></td>
187<td><p>Click to open the <a class="reference internal" href="psql_tool.html#psql-tool"><span class="std std-ref">PSQL Tool</span></a> and start PSQL in the current database context.</p></td>
188</tr>
189<tr class="row-odd"><td><p><em>Query tool</em></p></td>
190<td><p>Click to open the <a class="reference internal" href="query_tool.html#query-tool"><span class="std std-ref">Query tool</span></a> for the currently selected object.</p></td>
191</tr>
192<tr class="row-even"><td><p><em>Schema Diff</em></p></td>
193<td><p>Click to open the <a class="reference internal" href="schema_diff.html#schema-diff-feature"><span class="std std-ref">Schema Diff</span></a> and start comparing two database or two schema.</p></td>
194</tr>
195<tr class="row-odd"><td><p><em>Backup Globals…</em></p></td>
196<td><p>Click to open the <a class="reference internal" href="backup_globals_dialog.html#backup-globals-dialog"><span class="std std-ref">Backup Globals…</span></a> dialog to backup cluster objects.</p></td>
197</tr>
198<tr class="row-even"><td><p><em>Backup Server…</em></p></td>
199<td><p>Click to open the <a class="reference internal" href="backup_server_dialog.html#backup-server-dialog"><span class="std std-ref">Backup Server…</span></a> dialog to backup a server.</p></td>
200</tr>
201<tr class="row-odd"><td><p><em>Backup…</em></p></td>
202<td><p>Click to open the <a class="reference internal" href="backup_dialog.html#backup-dialog"><span class="std std-ref">Backup…</span></a> dialog to backup database objects.</p></td>
203</tr>
204<tr class="row-even"><td><p><em>Restore…</em></p></td>
205<td><p>Click to access the <a class="reference internal" href="restore_dialog.html#restore-dialog"><span class="std std-ref">Restore</span></a> dialog to restore database files from a backup.</p></td>
206</tr>
207<tr class="row-odd"><td><p><em>Import/Export Data…</em></p></td>
208<td><p>Click to open the <a class="reference internal" href="import_export_data.html#import-export-data"><span class="std std-ref">Import/Export data…</span></a> dialog to import or export data from a table.</p></td>
209</tr>
210<tr class="row-even"><td><p><em>Maintenance…</em></p></td>
211<td><p>Click to open the <a class="reference internal" href="maintenance_dialog.html#maintenance-dialog"><span class="std std-ref">Maintenance…</span></a> dialog to VACUUM, ANALYZE, REINDEX, or CLUSTER.</p></td>
212</tr>
213<tr class="row-odd"><td><p><em>Search Objects…</em></p></td>
214<td><p>Click to open the <a class="reference internal" href="search_objects.html#search-objects"><span class="std std-ref">Search Objects…</span></a> and start searching any kind of objects in a database.</p></td>
215</tr>
216<tr class="row-even"><td><p><em>Add named restore point</em></p></td>
217<td><p>Click to open the <a class="reference internal" href="add_restore_point_dialog.html#add-restore-point-dialog"><span class="std std-ref">Add named restore point…</span></a> dialog to take a point-in-time snapshot of the current
218server state.</p></td>
219</tr>
220<tr class="row-odd"><td><p><em>Pause replay of WAL</em></p></td>
221<td><p>Click to pause the replay of the WAL log.</p></td>
222</tr>
223<tr class="row-even"><td><p><em>Resume replay of WAL</em></p></td>
224<td><p>Click to resume the replay of the WAL log.</p></td>
225</tr>
226<tr class="row-odd"><td><p><em>Reload Configuration…</em></p></td>
227<td><p>Click to update configuration files without restarting the server.</p></td>
228</tr>
229<tr class="row-even"><td><p><em>Storage Manager</em></p></td>
230<td><p>Click to open the <a class="reference internal" href="storage_manager.html#storage-manager"><span class="std std-ref">Storage Manager</span></a> to upload, delete, or download the backup files.</p></td>
231</tr>
232</tbody>
233</table>
234</section>
235<section id="the-help-menu">
236<h2>The Help Menu<a class="headerlink" href="#the-help-menu" title="Link to this heading">¶</a></h2>
237<img alt="pgAdmin help menu bar" class="align-center" src="_images/help_menu.png" />
238<p>Use the options on the <em>Help</em> menu to access online help documents, or to review
239information about the pgAdmin installation (in alphabetical order):</p>
240<table class="docutils align-default">
241<thead>
242<tr class="row-odd"><th class="head"><p>Option</p></th>
243<th class="head"><p>Action</p></th>
244</tr>
245</thead>
246<tbody>
247<tr class="row-even"><td><p><em>Quick Search</em></p></td>
248<td><p>Type your keywords in the Quick Search field. Typing at least three characters will display all the matching possibilities under Menu
249items and the relevant documents under Help articles. Click on the options under Menu items to perform action of particular
250functionality or object. Click on any of the Help articles to open the help of that topic with highlighted text in a separate window.</p>
251<p><strong>Note</strong>:- If any of the option under Menu items is disabled, then it will provide information via info icon.</p>
252</td>
253</tr>
254<tr class="row-odd"><td><p><em>About pgAdmin 4</em></p></td>
255<td><p>Click to open a window where you will find information about pgAdmin; this includes the current version and the current user.</p></td>
256</tr>
257<tr class="row-even"><td><p><em>Online Help</em></p></td>
258<td><p>Click to open documentation support for using pgAdmin utilities, tools and dialogs.
259Navigate (in the newly opened tab?) help documents in the left browser pane or use the search bar to specify a topic.</p></td>
260</tr>
261<tr class="row-odd"><td><p><em>pgAdmin Website</em></p></td>
262<td><p>Click to open the <em>pgAdmin.org</em> website in a browser window.</p></td>
263</tr>
264<tr class="row-even"><td><p><em>PostgreSQL Website</em></p></td>
265<td><p>Click to access the PostgreSQL core documentation hosted at the PostgreSQL site. The site also offers guides, tutorials, and resources.</p></td>
266</tr>
267</tbody>
268</table>
269</section>
270</section>
271
272
273 <div class="clearer"></div>
274 </div>
275 </div>
276 </div>
277 <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
278 <div class="sphinxsidebarwrapper">
279 <div>
280 <h3><a href="index.html">Table of Contents</a></h3>
281 <ul>
282<li><a class="reference internal" href="#">Menu Bar</a><ul>
283<li><a class="reference internal" href="#the-file-menu">The File Menu</a></li>
284<li><a class="reference internal" href="#the-object-menu">The Object Menu</a></li>
285<li><a class="reference internal" href="#the-tools-menu">The Tools Menu</a></li>
286<li><a class="reference internal" href="#the-help-menu">The Help Menu</a></li>
287</ul>
288</li>
289</ul>
290
291 </div>
292<h3><a href="index.html">Table of Contents</a></h3>
293<ul class="current">
294<li class="toctree-l1 current"><a class="reference internal" href="getting_started.html">Getting Started</a><ul class="current">
295<li class="toctree-l2"><a class="reference internal" href="deployment.html">Deployment</a></li>
296<li class="toctree-l2"><a class="reference internal" href="login.html">Login Page</a></li>
297<li class="toctree-l2"><a class="reference internal" href="mfa.html">Enabling two-factor authentication (2FA)</a></li>
298<li class="toctree-l2"><a class="reference internal" href="user_management.html">User Management Dialog</a></li>
299<li class="toctree-l2"><a class="reference internal" href="change_ownership.html">Change Ownership Dialog</a></li>
300<li class="toctree-l2"><a class="reference internal" href="change_user_password.html">Change User Password Dialog</a></li>
301<li class="toctree-l2"><a class="reference internal" href="restore_locked_user.html">Lock/Restore Account</a></li>
302<li class="toctree-l2"><a class="reference internal" href="ldap.html">Enabling LDAP Authentication</a></li>
303<li class="toctree-l2"><a class="reference internal" href="kerberos.html">Enabling Kerberos Authentication</a></li>
304<li class="toctree-l2"><a class="reference internal" href="oauth2.html">Enabling OAUTH2 Authentication</a></li>
305<li class="toctree-l2"><a class="reference internal" href="webserver.html">Enabling Webserver Authentication</a></li>
306<li class="toctree-l2"><a class="reference internal" href="user_interface.html">User Interface</a></li>
307<li class="toctree-l2 current"><a class="current reference internal" href="#">Menu Bar</a></li>
308<li class="toctree-l2"><a class="reference internal" href="toolbar.html">Toolbar</a></li>
309<li class="toctree-l2"><a class="reference internal" href="tabbed_browser.html">Tabbed Browser</a></li>
310<li class="toctree-l2"><a class="reference internal" href="tree_control.html">Tree Control</a></li>
311<li class="toctree-l2"><a class="reference internal" href="preferences.html">Preferences Dialog</a></li>
312<li class="toctree-l2"><a class="reference internal" href="keyboard_shortcuts.html">Keyboard Shortcuts:</a></li>
313<li class="toctree-l2"><a class="reference internal" href="search_objects.html">Search objects</a></li>
314</ul>
315</li>
316<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
317<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
318<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
319<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
320<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
321<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
322<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
323<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
324<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
325<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
326<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
327<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
328<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
329</ul>
330
331<search id="searchbox" style="display: none" role="search">
332 <h3 id="searchlabel">Quick search</h3>
333 <div class="searchformwrapper">
334 <form class="search" action="search.html" method="get">
335 <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
336 <input type="submit" value="Go" />
337 </form>
338 </div>
339</search>
340<script>document.getElementById('searchbox').style.display = "block"</script>
341 </div>
342<div id="sidebarbutton" title="Collapse sidebar">
343<span>«</span>
344</div>
345
346 </div>
347 <div class="clearer"></div>
348 </div>
349 <div class="related" role="navigation" aria-label="related navigation">
350 <h3>Navigation</h3>
351 <ul>
352 <li class="right" style="margin-right: 10px">
353 <a href="genindex.html" title="General Index"
354 >index</a></li>
355 <li class="right" >
356 <a href="toolbar.html" title="Toolbar"
357 >next</a> |</li>
358 <li class="right" >
359 <a href="user_interface.html" title="User Interface"
360 >previous</a> |</li>
361 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
362 <li class="nav-item nav-item-1"><a href="getting_started.html" >Getting Started</a> »</li>
363 <li class="nav-item nav-item-this"><a href="">Menu Bar</a></li>
364 </ul>
365 </div>
366 <div class="footer" role="contentinfo">
367 <div class="related" role="navigation" aria-label="related navigation">
368 <ul>
369 <li class="left" style="margin-left: 10px">© Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
370 <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
371 <li class="right" ><a href="toolbar.html" title="Toolbar" accesskey="N">next</a> |</li>
372 <li class="right" ><a href="user_interface.html" title="User Interface" accesskey="P">previous</a> |</li>
373 </ul>
374 </div>
375 </div>
376 </body>
377</html>