Datasetpublic
codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face
1likes14kdownloads
rootpgsqlpgAdmin 4docsen_UShtmlmanaging_database_objects.html
managing_database_objects.html191 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>Managing Database Objects &#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="Cast Dialog" href="cast_dialog.html" />
23    <link rel="prev" title="Role Reassign/Drop Own Dialog" href="role_reassign_dialog.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="cast_dialog.html" title="Cast Dialog"
33             accesskey="N">next</a> |</li>
34        <li class="right" >
35          <a href="role_reassign_dialog.html" title="Role Reassign/Drop Own Dialog"
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-this"><a href="">Managing Database Objects</a></li> 
39      </ul>
40    </div>  
41
42    <div class="document">
43      <div class="documentwrapper">
44        <div class="bodywrapper">
45          <div class="body" role="main">
46            
47  <section id="managing-database-objects">
48<span id="id1"></span><h1><span class="target" id="index-0"></span>Managing Database Objects<a class="headerlink" href="#managing-database-objects" title="Link to this heading">¶</a></h1>
49<p>pgAdmin 4 provides simple but powerful dialogs that you can use to design and
50create database objects.  Each dialog contains a series of tabs that you use to
51describe the object that will be created by the dialog; the SQL tab displays the
52SQL command that the server will execute when creating the object.</p>
53<p>To access a dialog that allows you to create a database object, right-click on
54the object type in the pgAdmin tree control, and select the <em>Create</em> option for
55that object.  For example, to create a new cast, right-click on the <em>Casts</em>
56node, and select <em>Create Cast…</em></p>
57<div class="toctree-wrapper compound">
58<ul>
59<li class="toctree-l1"><a class="reference internal" href="cast_dialog.html">Cast Dialog</a></li>
60<li class="toctree-l1"><a class="reference internal" href="dbms_job_scheduler.html">Using EDB Job Scheduler</a></li>
61<li class="toctree-l1"><a class="reference internal" href="collation_dialog.html">Collation Dialog</a></li>
62<li class="toctree-l1"><a class="reference internal" href="domain_dialog.html">Domain Dialog</a></li>
63<li class="toctree-l1"><a class="reference internal" href="domain_constraint_dialog.html">Domain Constraints Dialog</a></li>
64<li class="toctree-l1"><a class="reference internal" href="event_trigger_dialog.html">Event Trigger Dialog</a></li>
65<li class="toctree-l1"><a class="reference internal" href="extension_dialog.html">Extension Dialog</a></li>
66<li class="toctree-l1"><a class="reference internal" href="foreign_data_wrapper_dialog.html">Foreign Data Wrapper Dialog</a></li>
67<li class="toctree-l1"><a class="reference internal" href="foreign_server_dialog.html">Foreign Server Dialog</a></li>
68<li class="toctree-l1"><a class="reference internal" href="foreign_table_dialog.html">Foreign Table Dialog</a></li>
69<li class="toctree-l1"><a class="reference internal" href="fts_configuration_dialog.html">FTS Configuration Dialog</a></li>
70<li class="toctree-l1"><a class="reference internal" href="fts_dictionary_dialog.html">FTS Dictionary Dialog</a></li>
71<li class="toctree-l1"><a class="reference internal" href="fts_parser_dialog.html">FTS Parser Dialog</a></li>
72<li class="toctree-l1"><a class="reference internal" href="fts_template_dialog.html">FTS Template Dialog</a></li>
73<li class="toctree-l1"><a class="reference internal" href="function_dialog.html">Function Dialog</a></li>
74<li class="toctree-l1"><a class="reference internal" href="language_dialog.html">Language Dialog</a></li>
75<li class="toctree-l1"><a class="reference internal" href="materialized_view_dialog.html">Materialized View Dialog</a></li>
76<li class="toctree-l1"><a class="reference internal" href="package_dialog.html">Package Dialog</a></li>
77<li class="toctree-l1"><a class="reference internal" href="procedure_dialog.html">Procedure Dialog</a></li>
78<li class="toctree-l1"><a class="reference internal" href="publication_dialog.html">Publication Dialog</a></li>
79<li class="toctree-l1"><a class="reference internal" href="schema_dialog.html">Schema Dialog</a></li>
80<li class="toctree-l1"><a class="reference internal" href="sequence_dialog.html">Sequence Dialog</a></li>
81<li class="toctree-l1"><a class="reference internal" href="subscription_dialog.html">Subscription Dialog</a></li>
82<li class="toctree-l1"><a class="reference internal" href="synonym_dialog.html">Synonym Dialog</a></li>
83<li class="toctree-l1"><a class="reference internal" href="trigger_function_dialog.html">Trigger Function Dialog</a></li>
84<li class="toctree-l1"><a class="reference internal" href="type_dialog.html">Type Dialog</a></li>
85<li class="toctree-l1"><a class="reference internal" href="user_mapping_dialog.html">User Mapping Dialog</a></li>
86<li class="toctree-l1"><a class="reference internal" href="view_dialog.html">View Dialog</a></li>
87</ul>
88</div>
89</section>
90
91
92            <div class="clearer"></div>
93          </div>
94        </div>
95      </div>
96      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
97        <div class="sphinxsidebarwrapper">
98<h3><a href="index.html">Table of Contents</a></h3>
99<ul class="current">
100<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
101<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
102<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
103<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
104<li class="toctree-l1 current"><a class="current reference internal" href="#">Managing Database Objects</a><ul>
105<li class="toctree-l2"><a class="reference internal" href="cast_dialog.html">Cast Dialog</a></li>
106<li class="toctree-l2"><a class="reference internal" href="dbms_job_scheduler.html">Using EDB Job Scheduler</a></li>
107<li class="toctree-l2"><a class="reference internal" href="collation_dialog.html">Collation Dialog</a></li>
108<li class="toctree-l2"><a class="reference internal" href="domain_dialog.html">Domain Dialog</a></li>
109<li class="toctree-l2"><a class="reference internal" href="domain_constraint_dialog.html">Domain Constraints Dialog</a></li>
110<li class="toctree-l2"><a class="reference internal" href="event_trigger_dialog.html">Event Trigger Dialog</a></li>
111<li class="toctree-l2"><a class="reference internal" href="extension_dialog.html">Extension Dialog</a></li>
112<li class="toctree-l2"><a class="reference internal" href="foreign_data_wrapper_dialog.html">Foreign Data Wrapper Dialog</a></li>
113<li class="toctree-l2"><a class="reference internal" href="foreign_server_dialog.html">Foreign Server Dialog</a></li>
114<li class="toctree-l2"><a class="reference internal" href="foreign_table_dialog.html">Foreign Table Dialog</a></li>
115<li class="toctree-l2"><a class="reference internal" href="fts_configuration_dialog.html">FTS Configuration Dialog</a></li>
116<li class="toctree-l2"><a class="reference internal" href="fts_dictionary_dialog.html">FTS Dictionary Dialog</a></li>
117<li class="toctree-l2"><a class="reference internal" href="fts_parser_dialog.html">FTS Parser Dialog</a></li>
118<li class="toctree-l2"><a class="reference internal" href="fts_template_dialog.html">FTS Template Dialog</a></li>
119<li class="toctree-l2"><a class="reference internal" href="function_dialog.html">Function Dialog</a></li>
120<li class="toctree-l2"><a class="reference internal" href="language_dialog.html">Language Dialog</a></li>
121<li class="toctree-l2"><a class="reference internal" href="materialized_view_dialog.html">Materialized View Dialog</a></li>
122<li class="toctree-l2"><a class="reference internal" href="package_dialog.html">Package Dialog</a></li>
123<li class="toctree-l2"><a class="reference internal" href="procedure_dialog.html">Procedure Dialog</a></li>
124<li class="toctree-l2"><a class="reference internal" href="publication_dialog.html">Publication Dialog</a></li>
125<li class="toctree-l2"><a class="reference internal" href="schema_dialog.html">Schema Dialog</a></li>
126<li class="toctree-l2"><a class="reference internal" href="sequence_dialog.html">Sequence Dialog</a></li>
127<li class="toctree-l2"><a class="reference internal" href="subscription_dialog.html">Subscription Dialog</a></li>
128<li class="toctree-l2"><a class="reference internal" href="synonym_dialog.html">Synonym Dialog</a></li>
129<li class="toctree-l2"><a class="reference internal" href="trigger_function_dialog.html">Trigger Function Dialog</a></li>
130<li class="toctree-l2"><a class="reference internal" href="type_dialog.html">Type Dialog</a></li>
131<li class="toctree-l2"><a class="reference internal" href="user_mapping_dialog.html">User Mapping Dialog</a></li>
132<li class="toctree-l2"><a class="reference internal" href="view_dialog.html">View Dialog</a></li>
133</ul>
134</li>
135<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
136<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
137<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
138<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
139<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
140<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
141<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
142<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
143<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
144</ul>
145
146<search id="searchbox" style="display: none" role="search">
147  <h3 id="searchlabel">Quick search</h3>
148    <div class="searchformwrapper">
149    <form class="search" action="search.html" method="get">
150      <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
151      <input type="submit" value="Go" />
152    </form>
153    </div>
154</search>
155<script>document.getElementById('searchbox').style.display = "block"</script>
156        </div>
157<div id="sidebarbutton" title="Collapse sidebar">
158<span>«</span>
159</div>
160
161      </div>
162      <div class="clearer"></div>
163    </div>
164    <div class="related" role="navigation" aria-label="related navigation">
165      <h3>Navigation</h3>
166      <ul>
167        <li class="right" style="margin-right: 10px">
168          <a href="genindex.html" title="General Index"
169             >index</a></li>
170        <li class="right" >
171          <a href="cast_dialog.html" title="Cast Dialog"
172             >next</a> |</li>
173        <li class="right" >
174          <a href="role_reassign_dialog.html" title="Role Reassign/Drop Own Dialog"
175             >previous</a> |</li>
176        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
177        <li class="nav-item nav-item-this"><a href="">Managing Database Objects</a></li> 
178      </ul>
179    </div>
180    <div class="footer" role="contentinfo">
181        <div class="related" role="navigation" aria-label="related navigation">
182          <ul>
183              <li class="left" style="margin-left: 10px">&#169; Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
184            <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
185            <li class="right" ><a href="cast_dialog.html" title="Cast Dialog" accesskey="N">next</a> |</li>
186            <li class="right" ><a href="role_reassign_dialog.html" title="Role Reassign/Drop Own Dialog" accesskey="P">previous</a> |</li>
187          </ul>
188        </div>
189    </div>
190  </body>
191</html>