Re: Create table with GUI

<div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:16px"><div
id="yui_3_16_0_1_1419257148883_6129">TheGraphical _QUERY_ Builder in the SQL Editor will only allow you to create
QUERIES.It cannot be used to create tables.</div><div id="yui_3_16_0_1_1419257148883_6128"><br /></div><div
id="yui_3_16_0_1_1419257148883_8416">Youcan also create objects in the tree view.</div><div dir="ltr"
id="yui_3_16_0_1_1419257148883_7877">Ifyou right click on Databases, you can create another database.</div><div
dir="ltr"id="yui_3_16_0_1_1419257148883_7448">If you Click on the Plus (+) sign next to the Database in the tree
view,</div><divdir="ltr" id="yui_3_16_0_1_1419257148883_7451">you will see Catalogs, Extensions &
Schemas.</div><divdir="ltr" id="yui_3_16_0_1_1419257148883_8415">If you right click on Schemas, you can create more
Schemas.<br/></div><div dir="ltr" id="yui_3_16_0_1_1419257148883_7876">Tables are created in Schemas. So right click on
aschema and you will <br /></div><div dir="ltr" id="yui_3_16_0_1_1419257148883_8417">see the option to create a
table.<br/></div><div dir="ltr" id="yui_3_16_0_1_1419257148883_9035">After you create a table, you can Click on the
Plus(+) sign next to the Schema to see the created table.</div><div dir="ltr" id="yui_3_16_0_1_1419257148883_9069"><br
/></div><divdir="ltr" id="yui_3_16_0_1_1419257148883_9070">There is also a video tutorial that walks you through the
wholeprocess.</div><div dir="ltr" id="yui_3_16_0_1_1419257148883_9072"><br /></div><a
href="http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/videos/how-create-postgres-database-using-pgadmin"
id="yui_3_16_0_1_1419257148883_9193">Howto Create a Postgres Database Using pgAdmin | EnterpriseDB</a><div
class="link-enhancr-attachmentlink-enhancr-element" contenteditable="false" id="enhancrCard_0" style="width:450px;
font-family:'Georgia', 'Times', 'Times New Roman', 'serif';margin-top:5px; margin-bottom: 5px; background-color:
#ffffff;"><tableborder="0" cellpadding="0" cellspacing="0" class="link-enhancr-element"
id="yui_3_16_0_1_1419257148883_10544"style="width:450px; height:auto; position: relative; display: block;"><tbody
id="yui_3_16_0_1_1419257148883_10543"><trclass="link-enhancr-element"><td class="link-enhancr-element" colspan="7"
style="height:1px; background-color: #e5e5e5; font-size: 1px; border-collapse: collapse;"><div
class="link-enhancr-element"style="height: 1px; background-color: #e5e5e5; font-size: 1px;
line-height:0px;"> </div></td></tr><trclass="link-enhancr-element"><td class="link-enhancr-element" rowspan="5"
style="width:1px; background-color: #e5e5e5; font-size: 1pt; border-collapse: collapse;"><div
class="link-enhancr-element"style="width: 1px; background-color: #e5e5e5; font-size: 1pt;"> </div></td><td
class="link-enhancr-element"rowspan="5" style="width: 14px; background-color: #ffffff; font-size: 0pt; border-collapse:
collapse;"><divclass="link-enhancr-element" style="width: 14px; background-color: #ffffff; font-size:
14pt;"> </div></td><tdclass="link-enhancr-element" colspan="2" style="height: 6px; background-color: #ffffff;
font-size:0pt; border-collapse: collapse;"><div class="link-enhancr-element" style="height: 6px; background-color:
#ffffff;font-size: 6pt;"> </div></td><td class="link-enhancr-element" rowspan="5" style="width: 20px; background-color:
#ffffff;font-size: 0pt; border-collapse: collapse;"><div class="link-enhancr-element" style="width: 20px;
background-color:#ffffff; font-size: 20pt;"> </div></td><td class="link-enhancr-element" rowspan="5" style="width: 1px;
background-color:#e5e5e5; font-size: 1pt; border-collapse: collapse;" width="1"><div class="link-enhancr-element"
style="width:1px; background-color: #e5e5e5; font-size: 1pt;"> </div></td></tr><tr
id="yui_3_16_0_1_1419257148883_10542"><tdclass="link-enhancr-element" colspan="2" id="yui_3_16_0_1_1419257148883_10541"
style="width:100%; vertical-align: middle; font-family: 'Georgia', 'Times', 'Times New Roman', 'serif';"><div
class="link-enhancr-text-partlink-enhancr-element" id="yui_3_16_0_1_1419257148883_10540" style="line-height:16.5px;
background-color:#ffffff;  width: 414px;"><div class="link-enhancr-element" id="yui_3_16_0_1_1419257148883_10539"
style="word-wrap:break-word; word-break: break-all;"><span class="link-enhancr-element icon  icon-shrink
link-enhancr-toggle"></span><spanclass="link-enhancr-element icon icon-close link-enhancr-delete"></span><a
class="link-enhancr-card-urlWrapperlink-enhancr-element"
href="http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/videos/how-create-postgres-database-using-pgadmin"
id="yui_3_16_0_1_1419257148883_10538"style="text-decoration: none !important; color: #000000 !important; line-height:
100%;font-size: 18px; display: block;"><span class="link-enhancr-element link-enhancr-card-title"
id="yui_3_16_0_1_1419257148883_10537"style="margin: 0; font-weight: normal;margin-bottom: 3px; font-size: 18px;
line-height:21px; max-height: 43px; color: #000000; overflow: hidden !important; display: inline-block;">How to Create
aPostgres Database Using pgAdmin | EnterpriseDB</span></a><div class="link-enhancr-card-description
link-enhancr-element"id="yui_3_16_0_1_1419257148883_10545" style="font-size: 13px; line-height: 20px; color: #999999;
max-height:81px; font-family: 'Georgia', 'Times', 'Times New Roman', 'serif';overflow: hidden;">Spend 10 minutes with
Garyas he walks through the basics of creating your first database using pgAdmin, the comprehensive database design and
managementconsole for Postgres databases.</div></div></div></td></tr><tr id="yui_3_16_0_1_1419257148883_10548"><td
class="link-enhancr-element"colspan="2" id="yui_3_16_0_1_1419257148883_10547" style="height: 6px; background-color:
#ffffff;font-size: 0pt; border-collapse: collapse;"><div class="link-enhancr-element"
id="yui_3_16_0_1_1419257148883_10546"style="height: 6px; background-color: #ffffff; font-size:
6pt;"></div></td></tr><trid="yui_3_16_0_1_1419257148883_10554"><td class="link-enhancr-element" style="vertical-align:
middle;font-family: 'Arial', 'Helvetica Neue', 'Helvetica', 'sans-serif';"><div class="link-enhancr-element"
style="font-size:0pt;"><a class="link-enhancr-card-url link-enhancr-element"
href="http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/videos/how-create-postgres-database-using-pgadmin"
style="color:black; text-decoration: none !important;cursor:pointer !important;" target="_blank"><span
class="link-enhancr-elementlink-enhancr-view-on" id="yui_3_16_0_1_1419257148883_9867" style="display: inline-block;
line-height:11px; max-width: 314px; min-width: 254px; overflow: hidden; max-height: 13px; word-break: break-all;"><span
class="link-enhancr-elementlink-enhancr-mobile-no-resize" style="vertical-align:middle; font-size: 9px; line-height:
11px;color: #999999; -moz-text-size-adjust: none; -ms-text-size-adjust: none; -webkit-text-size-adjust:none;
text-size-adjust:none;">Viewon <span class="link-enhancr-view-on-domain" style="font-weight:
bold">www.enterprisedb.com</span></span></span></a></div></td><tdclass="link-enhancr-element"
id="yui_3_16_0_1_1419257148883_10553"style="vertical-align: middle; width: 100px; font-family: 'Arial', 'Helvetica
Neue','Helvetica', 'sans-serif';"><div class="link-enhancr-element link-enhancr-preview-wrapper"
id="yui_3_16_0_1_1419257148883_10552"style="max-width: 100px; min-width: 80px; overflow: hidden; text-align: right;
line-height:11px; max-height: 13px; font-size: 0pt;"><span class="link-enhancr-element link-enhancr-preview-by
link-enhancr-mobile-no-resize"id="yui_3_16_0_1_1419257148883_10551" style="vertical-align:middle; font-size: 9px;
line-height:11px; color: #999999; -moz-text-size-adjust: none; -ms-text-size-adjust: none;
-webkit-text-size-adjust:none;text-size-adjust:none;">Preview by Yahoo</span></div></td></tr><tr
id="yui_3_16_0_1_1419257148883_10557"><tdclass="link-enhancr-element" colspan="2" id="yui_3_16_0_1_1419257148883_10556"
style="height:9px; background-color: #ffffff; font-size: 0pt; border-collapse: collapse;"><div
class="link-enhancr-element"id="yui_3_16_0_1_1419257148883_10555" style="height: 9px; background-color: #ffffff;
font-size:9pt;"></div></td></tr><tr class="link-enhancr-element"><td class="link-enhancr-element" colspan="7"
style="height:1px; background-color: #e5e5e5; font-size: 1px; border-collapse: collapse;"><div
class="link-enhancr-element"style="height: 1px; background-color: #e5e5e5; font-size: 1px;
line-height:0px"> </div></td></tr></tbody></table></div><divdir="ltr" id="yui_3_16_0_1_1419257148883_7452"><br
/></div> <divclass="signature" id="yui_3_16_0_1_1419257148883_5831"><div id="RTEContent"><font
id="yui_3_16_0_1_1419257148883_7904"size="4"><span id="yui_3_16_0_1_1419257148883_7903"
style="font-weight:bold;font-family:arial;color:rgb(0,0, 255);">Melvin Davidson </span></font><br /><br /><font
id="yui_3_16_0_1_1419257148883_5833"size="3" style="font-weight:bold;"><span id="yui_3_16_0_1_1419257148883_5832"
style="color:rgb(128,0, 255);">I reserve the right to fantasize.  Whether or not you </span><br style="color:rgb(128,
0,255);" /><span id="yui_3_16_0_1_1419257148883_5834" style="color:rgb(128, 0, 255);">wish to share my fantasy is
entirelyup to you. </span><img data-id="a4359b5a-59fc-7a6f-c89c-f27a3a8a0e6e"
src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"style="color:rgb(128, 0, 255);" /><br /><br
/></font><fontid="yui_3_16_0_1_1419257148883_6131" size="3"><span id="yui_3_16_0_1_1419257148883_6413"
style="font-weight:bold;font-family:courier;">FolkAlley - All Folk - 24 Hours a day </span><span
id="yui_3_16_0_1_1419257148883_6130"style="font-weight:bold;font-family:courier;"><br />www.folkalley.com<br /><br
/></span></font></div></div><br/><div id="yui_3_16_0_1_1419257148883_5864" style="font-family: verdana, helvetica,
sans-serif;font-size: 16px;"><div id="yui_3_16_0_1_1419257148883_5863" style="font-family: HelveticaNeue, Helvetica
Neue,Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"><div dir="ltr"
id="yui_3_16_0_1_1419257148883_5862"><hrid="yui_3_16_0_1_1419257148883_10569" size="1" /><font face="Arial"
id="yui_3_16_0_1_1419257148883_6134"size="2"> <b id="yui_3_16_0_1_1419257148883_6133"><span
id="yui_3_16_0_1_1419257148883_6132"style="font-weight:bold;">From:</span></b> "moonkid@posteo.org"
<moonkid@posteo.org><br/><b id="yui_3_16_0_1_1419257148883_10571"><span id="yui_3_16_0_1_1419257148883_10570"
style="font-weight:bold;">To:</span></b> pgadmin-support@postgresql.org <br /><b><span style="font-weight:
bold;">Sent:</span></b>Monday, December 22, 2014 5:48 AM<br /><b><span style="font-weight: bold;">Subject:</span></b>
[pgadmin-support]Create table with GUI<br /></font></div><div class="y_msg_container"
id="yui_3_16_0_1_1419257148883_5865"><br/>The list language is english, correct?<br /><br />I am using PostGreSql9.3 on
Kubuntu14.04with pgAdmin III (release <br />1.18.1).<br />I have a conected but empty databse in there.<br /><br />I
wantto create a table with the GUI (not SQL!). In the office docu of <br />pgAdmin I miss the topic "Create a
table".<br/>All descriptions and tutorials in the web describe it with SQL. I know <br />SQL but don't want to use it
forsuch a simple task. I don't need a GUI <br />to use SQL. ;)<br /><br />The point is I don't understand the
elements/itemsof the TreeView. I <br />miss the documentation about it, too.<br />There is my "database" and under it
is"Schemata -> public -> tables".<br />But....<br />Beside (on the same tree-level) my "database" is
"Tablespaces".<br/><br />Where can I create my own tables? Maybe you can link the documentation <br />about the
descriptionof the tree-elements?<br /><br />Thank you very much<br />Christian<br /><br /><br />-- <br />Sent via
pgadmin-supportmailing list (<a href="mailto:pgadmin-support@postgresql.org"
ymailto="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br/>To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgadmin-support"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/><br /><br /></div></div></div></div>