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>Search objects — 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="External database for pgAdmin user settings" href="external_database.html" />
23 <link rel="prev" title="Keyboard Shortcuts:" href="keyboard_shortcuts.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="external_database.html" title="External database for pgAdmin user settings"
33 accesskey="N">next</a> |</li>
34 <li class="right" >
35 <a href="keyboard_shortcuts.html" title="Keyboard Shortcuts:"
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="">Search objects</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="search-objects">
49<span id="id1"></span><h1><span class="target" id="index-0"></span>Search objects<a class="headerlink" href="#search-objects" title="Link to this heading">¶</a></h1>
50<img alt="Search objects dialog" class="align-center" src="_images/search_objects.png" />
51<p>With this dialog, you can search for almost any kind of objects in a
52database.</p>
53<p>You can access it by right clicking a database or any of its child nodes
54and select “Search objects”. You can also access it by hitting the
55shortcut (default ALT+SHIFT+S).</p>
56<p>The minimum pattern length are 3 characters. The search performed is
57non-casesensitive and will find all objets whose name contains the pattern.
58You can only search for object names currently. Examples are: abc,
59%ab%, ab%c, %%%, etc.</p>
60<p>The result is presented in the grid with object name, object type and
61the object path in the <a class="reference internal" href="tree_control.html#tree-control"><span class="std std-ref">object explorer</span></a>. You can double
62click on a result row to select the object in the
63<a class="reference internal" href="tree_control.html#tree-control"><span class="std std-ref">object explorer</span></a>. If the object is greyed out, this means that you
64have not enabled those object types in the <a class="reference internal" href="preferences.html#preferences"><span class="std std-ref">preferences</span></a>,
65so you can’t double click on it. You can click on the ellipsis appended to
66the function and procedure names to see their arguments.</p>
67<p>You can filter based on a particular object type by selecting one from the
68object type dropdown. If the search button is hit when one of the object type
69is selected then only those types will be fetch from the database.
70An object type will not be visible in the dropdown if the database server
71does not support it or if it is not enabled from the
72<a class="reference internal" href="preferences.html#preferences"><span class="std std-ref">preferences</span></a>.</p>
73</section>
74
75
76 <div class="clearer"></div>
77 </div>
78 </div>
79 </div>
80 <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
81 <div class="sphinxsidebarwrapper">
82<h3><a href="index.html">Table of Contents</a></h3>
83<ul class="current">
84<li class="toctree-l1 current"><a class="reference internal" href="getting_started.html">Getting Started</a><ul class="current">
85<li class="toctree-l2"><a class="reference internal" href="deployment.html">Deployment</a></li>
86<li class="toctree-l2"><a class="reference internal" href="login.html">Login Page</a></li>
87<li class="toctree-l2"><a class="reference internal" href="mfa.html">Enabling two-factor authentication (2FA)</a></li>
88<li class="toctree-l2"><a class="reference internal" href="user_management.html">User Management Dialog</a></li>
89<li class="toctree-l2"><a class="reference internal" href="change_ownership.html">Change Ownership Dialog</a></li>
90<li class="toctree-l2"><a class="reference internal" href="change_user_password.html">Change User Password Dialog</a></li>
91<li class="toctree-l2"><a class="reference internal" href="restore_locked_user.html">Lock/Restore Account</a></li>
92<li class="toctree-l2"><a class="reference internal" href="ldap.html">Enabling LDAP Authentication</a></li>
93<li class="toctree-l2"><a class="reference internal" href="kerberos.html">Enabling Kerberos Authentication</a></li>
94<li class="toctree-l2"><a class="reference internal" href="oauth2.html">Enabling OAUTH2 Authentication</a></li>
95<li class="toctree-l2"><a class="reference internal" href="webserver.html">Enabling Webserver Authentication</a></li>
96<li class="toctree-l2"><a class="reference internal" href="user_interface.html">User Interface</a></li>
97<li class="toctree-l2"><a class="reference internal" href="menu_bar.html">Menu Bar</a></li>
98<li class="toctree-l2"><a class="reference internal" href="toolbar.html">Toolbar</a></li>
99<li class="toctree-l2"><a class="reference internal" href="tabbed_browser.html">Tabbed Browser</a></li>
100<li class="toctree-l2"><a class="reference internal" href="tree_control.html">Tree Control</a></li>
101<li class="toctree-l2"><a class="reference internal" href="preferences.html">Preferences Dialog</a></li>
102<li class="toctree-l2"><a class="reference internal" href="keyboard_shortcuts.html">Keyboard Shortcuts:</a></li>
103<li class="toctree-l2 current"><a class="current reference internal" href="#">Search objects</a></li>
104</ul>
105</li>
106<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
107<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
108<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
109<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
110<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
111<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
112<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
113<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
114<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
115<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
116<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
117<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
118<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
119</ul>
120
121<search id="searchbox" style="display: none" role="search">
122 <h3 id="searchlabel">Quick search</h3>
123 <div class="searchformwrapper">
124 <form class="search" action="search.html" method="get">
125 <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
126 <input type="submit" value="Go" />
127 </form>
128 </div>
129</search>
130<script>document.getElementById('searchbox').style.display = "block"</script>
131 </div>
132<div id="sidebarbutton" title="Collapse sidebar">
133<span>«</span>
134</div>
135
136 </div>
137 <div class="clearer"></div>
138 </div>
139 <div class="related" role="navigation" aria-label="related navigation">
140 <h3>Navigation</h3>
141 <ul>
142 <li class="right" style="margin-right: 10px">
143 <a href="genindex.html" title="General Index"
144 >index</a></li>
145 <li class="right" >
146 <a href="external_database.html" title="External database for pgAdmin user settings"
147 >next</a> |</li>
148 <li class="right" >
149 <a href="keyboard_shortcuts.html" title="Keyboard Shortcuts:"
150 >previous</a> |</li>
151 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
152 <li class="nav-item nav-item-1"><a href="getting_started.html" >Getting Started</a> »</li>
153 <li class="nav-item nav-item-this"><a href="">Search objects</a></li>
154 </ul>
155 </div>
156 <div class="footer" role="contentinfo">
157 <div class="related" role="navigation" aria-label="related navigation">
158 <ul>
159 <li class="left" style="margin-left: 10px">© Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
160 <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
161 <li class="right" ><a href="external_database.html" title="External database for pgAdmin user settings" accesskey="N">next</a> |</li>
162 <li class="right" ><a href="keyboard_shortcuts.html" title="Keyboard Shortcuts:" accesskey="P">previous</a> |</li>
163 </ul>
164 </div>
165 </div>
166 </body>
167</html>