Re: Accessing SQL that has been executed behind the interface
От | Melvin Davidson |
---|---|
Тема | Re: Accessing SQL that has been executed behind the interface |
Дата | |
Msg-id | 138225329.13572446.1448976645162.JavaMail.yahoo@mail.yahoo.com обсуждение исходный текст |
Ответ на | Accessing SQL that has been executed behind the interface (Wizz <mastuh8@gmail.com>) |
Список | pgadmin-support |
<div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:24px"><divdir="ltr" id="yui_3_16_0_1_1448975735269_9563">>>How can I access the SQL that executeswhen I <br /></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9601">>>alter my tables...</div><div dir="ltr"id="yui_3_16_0_1_1448975735269_9881"><br /></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9564">There are twoways, the first is the change to uncomment and change the value of <span class="" id="yui_3_16_0_1_1448975735269_9586">log_statementin</span></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9880"><spanclass="" id="yui_3_16_0_1_1448975735269_9586">postgresql.conf to ddl</span></div><divdir="ltr" id="yui_3_16_0_1_1448975735269_9879"><span class="" id="yui_3_16_0_1_1448975735269_9586">IE:<br/></span></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9538"><span id="yui_3_16_0_1_1448975735269_9586">log_statement= 'ddl'</span></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9721"><br/><span id="yui_3_16_0_1_1448975735269_9586"></span></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9720"><spanid="yui_3_16_0_1_1448975735269_9586">Then you must do a reload of the postgresql.conf.</span></div><divdir="ltr" id="yui_3_16_0_1_1448975735269_9883"><span id="yui_3_16_0_1_1448975735269_9586">ddlstatements will then be captured to the log.<br /></span></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9709"><br/><span id="yui_3_16_0_1_1448975735269_9586"></span></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9708"><spanid="yui_3_16_0_1_1448975735269_9586">The other way is to make the changes to thetable in properties.</span></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9747"><span id="yui_3_16_0_1_1448975735269_9586">A.right click on the table</span></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9758"><spanid="yui_3_16_0_1_1448975735269_9586">B. left click on Properties...</span></div><divdir="ltr" id="yui_3_16_0_1_1448975735269_9819"><span id="yui_3_16_0_1_1448975735269_9586">C.Add column, constraints, etc as needed.</span></div><div dir="ltr" id="yui_3_16_0_1_1448975735269_9864"><spanid="yui_3_16_0_1_1448975735269_9586">D. Click on the SQL tab _BEFORE_ clickingthe OK button,<br /></span></div> <div class="signature" id="yui_3_16_0_1_1448975735269_9498"><div id="RTEContent"><fontsize="4"><span style="font-weight:bold;font-family:arial;color:rgb(0, 0, 255);">Melvin Davidson </span></font><br/><font id="yui_3_16_0_1_1448975735269_9820" size="3"> Cell 720-320-0155 <br /></font><br /><font id="yui_3_16_0_1_1448975735269_9522"size="3" style="font-weight:bold;"><span id="yui_3_16_0_1_1448975735269_9521" 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_1448975735269_9565" style="color:rgb(128, 0, 255);">wish to share my fantasy is entirelyup to you. </span><img data-id="9db6a728-01b9-a11c-946d-640120b15096" src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"style="color:rgb(128, 0, 255);" /><br /><br />www.youtube.com/unusedhero<brstyle="color:rgb(128, 0, 255);" /></font><br /><font id="yui_3_16_0_1_1448975735269_9520"size="3"><span id="yui_3_16_0_1_1448975735269_9519" style="font-weight:bold;font-family:courier;">FolkAlley - All Folk - 24 Hours a day </span><span 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_1448975735269_9570"style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 24px;"><divid="yui_3_16_0_1_1448975735269_9569" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, LucidaGrande, sans-serif; font-size: 16px;"><div dir="ltr" id="yui_3_16_0_1_1448975735269_9568"><hr id="yui_3_16_0_1_1448975735269_9567"size="1" /><font face="Arial" id="yui_3_16_0_1_1448975735269_9571" size="2"> <b><spanstyle="font-weight:bold;">From:</span></b> Wizz <mastuh8@gmail.com><br /><b><span style="font-weight: bold;">To:</span></b>pgadmin-support@postgresql.org <br /><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, December1, 2015 7:41 AM<br /><b><span style="font-weight: bold;">Subject:</span></b> [pgadmin-support] Accessing SQL thathas been executed behind the interface<br /></font></div><div class="y_msg_container" id="yui_3_16_0_1_1448975735269_9572"><br/>How can I access the SQL that executes when I alter my tables with the<br />pgAdmininterface.<br />For instance, if I add a column, without a doubt, there was a "ALTER TABLE<br />tablename ADD COLUMNcolumn name int;" executed in the background. How do I<br />get to it?<br />I need to make a bunch of changes to adatabase and then have those changes<br />in the form of SQL so I can pass it on to a colleague, who will execute it<br/>on an identical database.<br />Thank you!<br /><br /><br /><br />--<br />View this message in context: <a href="http://postgresql.nabble.com/Accessing-SQL-that-has-been-executed-behind-the-interface-tp5875650.html" target="_blank">http://postgresql.nabble.com/Accessing-SQL-that-has-been-executed-behind-the-interface-tp5875650.html</a><br />Sentfrom the PostgreSQL - pgadmin support mailing list archive at Nabble.com.<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 по дате отправления: