Re: Create table with GUI
От | Melvin Davidson |
---|---|
Тема | Re: Create table with GUI |
Дата | |
Msg-id | 2142270274.187609.1419258825188.JavaMail.yahoo@jws106116.mail.bf1.yahoo.com обсуждение исходный текст |
Ответ на | Create table with GUI (moonkid@posteo.org) |
Список | pgadmin-support |
<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>
В списке pgadmin-support по дате отправления: