http://www.sqlzoo.net/w/index.php?title=Starting_Postgres&feed=atom&action=history Starting Postgres - Revision history 2013-05-25T19:07:41Z Revision history for this page on the wiki MediaWiki 1.20.4 http://www.sqlzoo.net/w/index.php?title=Starting_Postgres&diff=1866&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">postgres</td> </tr> <tr> <th colspan="1" rowsp..." 2012-07-19T10:41: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;postgres&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;th colspan=&quot;1&quot; rowsp...&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;postgres&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;psql&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&lt;/th&gt;<br /> &lt;td colspan=&quot;1&quot; rowspan=&quot;1&quot; width=&quot;576&quot;&gt;&lt;tt&gt;psql -h server -d dbname -U username&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;the internet address of a computer running the server&lt;/p&gt; <br /> &lt;dt&gt;&lt;p&gt;dbname&lt;/p&gt;<br /> &lt;dd&gt;&lt;p&gt;the name of the database to use&lt;/p&gt; <br /> &lt;dt&gt;&lt;p&gt;username&lt;/p&gt;<br /> &lt;dd&gt;&lt;p&gt;database user name&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 /> \dt<br /> \i file.sql<br /> \c otherdbname&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;If results are wide the format is unreadable. \pset pager&lt;/p&gt;<br /> &lt;/td&gt;<br /> &lt;/tr&gt;<br /> <br /> &lt;/table&gt;<br /> &lt;p&gt;Thanks to Nicola Boni from Italy for supplying this.&lt;/p&gt;</div> Connor