Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes14kdownloads

LikeSaveClone

rootpgsqlpgAdmin 4docsen_UShtmlmodifying_tables.html

modifying_tables.html157 linesCopy pathDownload 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>Creating or Modifying a Table &#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="Check Dialog" href="check_dialog.html" />
23    <link rel="prev" title="View Dialog" href="view_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="check_dialog.html" title="Check Dialog"
33             accesskey="N">next</a> |</li>
34        <li class="right" >
35          <a href="view_dialog.html" title="View 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="">Creating or Modifying a Table</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="creating-or-modifying-a-table">
48<span id="modifying-tables"></span><h1><span class="target" id="index-0"></span>Creating or Modifying a Table<a class="headerlink" href="#creating-or-modifying-a-table" title="Link to this heading">¶</a></h1>
49<p>pgAdmin 4 provides dialogs that allow you to modify all table properties and
50attributes.</p>
51<p>To access a dialog that allows you to create a database object, right-click on
52the object type in the pgAdmin tree control, and select the <em>Create</em> option for
53that object.  For example, to create a new table, Select a database from the tree control, select the schema under the database, right-click on the <em>Tables</em>
54node, and select <em>Create Table…</em></p>
55<div class="toctree-wrapper compound">
56<ul>
57<li class="toctree-l1"><a class="reference internal" href="check_dialog.html">Check Dialog</a></li>
58<li class="toctree-l1"><a class="reference internal" href="column_dialog.html">Column Dialog</a></li>
59<li class="toctree-l1"><a class="reference internal" href="compound_trigger_dialog.html">Compound Trigger Dialog</a></li>
60<li class="toctree-l1"><a class="reference internal" href="exclusion_constraint_dialog.html">Exclusion Constraint Dialog</a></li>
61<li class="toctree-l1"><a class="reference internal" href="foreign_key_dialog.html">Foreign key Dialog</a></li>
62<li class="toctree-l1"><a class="reference internal" href="index_dialog.html">Index Dialog</a></li>
63<li class="toctree-l1"><a class="reference internal" href="primary_key_dialog.html">Primary key Dialog</a></li>
64<li class="toctree-l1"><a class="reference internal" href="rls_policy_dialog.html">RLS Policy Dialog</a></li>
65<li class="toctree-l1"><a class="reference internal" href="rule_dialog.html">Rule Dialog</a></li>
66<li class="toctree-l1"><a class="reference internal" href="table_dialog.html">Table Dialog</a></li>
67<li class="toctree-l1"><a class="reference internal" href="trigger_dialog.html">Trigger Dialog</a></li>
68<li class="toctree-l1"><a class="reference internal" href="unique_constraint_dialog.html">Unique Constraint Dialog</a></li>
69</ul>
70</div>
71</section>
72
73
74            <div class="clearer"></div>
75          </div>
76        </div>
77      </div>
78      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
79        <div class="sphinxsidebarwrapper">
80<h3><a href="index.html">Table of Contents</a></h3>
81<ul class="current">
82<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
83<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
84<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
85<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
86<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
87<li class="toctree-l1 current"><a class="current reference internal" href="#">Creating or Modifying a Table</a><ul>
88<li class="toctree-l2"><a class="reference internal" href="check_dialog.html">Check Dialog</a></li>
89<li class="toctree-l2"><a class="reference internal" href="column_dialog.html">Column Dialog</a></li>
90<li class="toctree-l2"><a class="reference internal" href="compound_trigger_dialog.html">Compound Trigger Dialog</a></li>
91<li class="toctree-l2"><a class="reference internal" href="exclusion_constraint_dialog.html">Exclusion Constraint Dialog</a></li>
92<li class="toctree-l2"><a class="reference internal" href="foreign_key_dialog.html">Foreign key Dialog</a></li>
93<li class="toctree-l2"><a class="reference internal" href="index_dialog.html">Index Dialog</a></li>
94<li class="toctree-l2"><a class="reference internal" href="primary_key_dialog.html">Primary key Dialog</a></li>
95<li class="toctree-l2"><a class="reference internal" href="rls_policy_dialog.html">RLS Policy Dialog</a></li>
96<li class="toctree-l2"><a class="reference internal" href="rule_dialog.html">Rule Dialog</a></li>
97<li class="toctree-l2"><a class="reference internal" href="table_dialog.html">Table Dialog</a></li>
98<li class="toctree-l2"><a class="reference internal" href="trigger_dialog.html">Trigger Dialog</a></li>
99<li class="toctree-l2"><a class="reference internal" href="unique_constraint_dialog.html">Unique Constraint Dialog</a></li>
100</ul>
101</li>
102<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
103<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
104<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
105<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
106<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
107<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
108<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
109<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
110</ul>
111
112<search id="searchbox" style="display: none" role="search">
113  <h3 id="searchlabel">Quick search</h3>
114    <div class="searchformwrapper">
115    <form class="search" action="search.html" method="get">
116      <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
117      <input type="submit" value="Go" />
118    </form>
119    </div>
120</search>
121<script>document.getElementById('searchbox').style.display = "block"</script>
122        </div>
123<div id="sidebarbutton" title="Collapse sidebar">
124<span>«</span>
125</div>
126
127      </div>
128      <div class="clearer"></div>
129    </div>
130    <div class="related" role="navigation" aria-label="related navigation">
131      <h3>Navigation</h3>
132      <ul>
133        <li class="right" style="margin-right: 10px">
134          <a href="genindex.html" title="General Index"
135             >index</a></li>
136        <li class="right" >
137          <a href="check_dialog.html" title="Check Dialog"
138             >next</a> |</li>
139        <li class="right" >
140          <a href="view_dialog.html" title="View Dialog"
141             >previous</a> |</li>
142        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
143        <li class="nav-item nav-item-this"><a href="">Creating or Modifying a Table</a></li> 
144      </ul>
145    </div>
146    <div class="footer" role="contentinfo">
147        <div class="related" role="navigation" aria-label="related navigation">
148          <ul>
149              <li class="left" style="margin-left: 10px">&#169; Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
150            <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
151            <li class="right" ><a href="check_dialog.html" title="Check Dialog" accesskey="N">next</a> |</li>
152            <li class="right" ><a href="view_dialog.html" title="View Dialog" accesskey="P">previous</a> |</li>
153          </ul>
154        </div>
155    </div>
156  </body>
157</html>