http://www.sqlzoo.net/w/index.php?title=Starting_Ingres&feed=atom&action=history Starting Ingres - Revision history 2013-05-21T08:23:49Z Revision history for this page on the wiki MediaWiki 1.20.4 http://www.sqlzoo.net/w/index.php?title=Starting_Ingres&diff=1867&oldid=prev Connor: Created page with "<table border="1"> <tr> <th colspan="1" rowspan="1" width="296">Name of the server</th> <td colspan="1" rowspan="1" width="576">ingres</td> </tr> <tr> <th colspan="1" rowspan..." 2012-07-19T10:43:07Z <p>Created page with &quot;&lt;table border=&quot;1&quot;&gt; &lt;tr&gt; &lt;th colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;296&quot;&gt;Name of the server&lt;/th&gt; &lt;td colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;576&quot;&gt;ingres&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;th colspan=&quot;1&quot; rowspan...&quot;</p> <p><b>New page</b></p><div>&lt;table border=&quot;1&quot;&gt;<br /> &lt;tr&gt;<br /> &lt;th colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;296&quot;&gt;Name of the server&lt;/th&gt;<br /> &lt;td colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;576&quot;&gt;ingres&lt;/td&gt;<br /> &lt;/tr&gt;<br /> <br /> &lt;tr&gt;<br /> &lt;th colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;296&quot;&gt;Name of the client&lt;/th&gt;<br /> &lt;td colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;576&quot;&gt;sql also isql&lt;/td&gt;<br /> &lt;/tr&gt;<br /> <br /> &lt;tr&gt;<br /> &lt;th colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;296&quot;&gt;Typical command line to start the client<br /> &lt;/th&gt;<br /> &lt;td colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;576&quot;&gt;&lt;tt&gt;source ~ingres/.ingIIbash&lt;br/&gt;sql iidbdb&lt;/tt&gt;<br /> &lt;dl&gt;<br /> &lt;dt&gt;&lt;p&gt;server&lt;/p&gt;<br /> &lt;dd&gt;&lt;p&gt;iidbdb is the system database - where you create users and databases&lt;/p&gt; <br /> &lt;dt&gt;&lt;p&gt;operating system authentication&lt;/p&gt;<br /> &lt;dd&gt;&lt;p&gt;Ingres relies on the operatong system for authentication.&lt;/p&gt; <br /> &lt;/dl&gt;<br /> &lt;/td&gt;<br /> &lt;/tr&gt;<br /> <br /> &lt;tr&gt;<br /> &lt;th colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;296&quot;&gt;Useful commands&lt;/th&gt;<br /> &lt;td colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;576&quot;&gt;&lt;pre space=&quot;preserve&quot;&gt;<br /> help\g<br /> &lt;/pre&gt;&lt;/td&gt;<br /> &lt;/tr&gt;<br /> <br /> &lt;tr&gt;<br /> &lt;th colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;296&quot;&gt;Beware!&lt;/th&gt;<br /> &lt;td colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;576&quot;&gt;<br /> &lt;p&gt;Put \g at the end of each sql command&lt;/p&gt;<br /> &lt;/td&gt;<br /> &lt;/tr&gt;<br /> <br /> &lt;/table&gt;</div> Connor