tag:blogger.com,1999:blog-5153119987440048886Fri, 20 Sep 2024 15:27:50 +0000PostgreSQLSQLaggregate functions index methodscomplex queriesdata typesforeign keysfunctionsmultiversion concurrency controloperatorstransactional integritytriggersviewshttp://sqlelcric.blogspot.com/noreply@blogger.com (Ron Tinnel)Blogger1125tag:blogger.com,1999:blog-5153119987440048886.post-4066297713478768213Wed, 30 Nov 2011 05:34:00 +00002013-03-03T22:37:16.263-05:00aggregate functions index methodscomplex queriesdata typesforeign keysfunctionsmultiversion concurrency controloperatorsPostgreSQLSQLtransactional integritytriggersviews<div dir="ltr" style="text-align: left;" trbidi="on"> <div dir="ltr" style="text-align: left;" trbidi="on"> <title>POSTGRESQL</title> <br /> <div class="g-plusone" data-annotation="inline" data-width="300"> </div> <script type="text/javascript"> (function() { var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true; po.src = 'https://apis.google.com/js/plusone.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s); })(); </script> <br /> <br /> <div> <form> <span class="Apple-style-span" style="font-size: xx-small;"><input onclick="window.location.href='http://goo.gl/Hm4Lb'" type="BUTTON" value="HOME PAGE" /> </span></form> </div> <div> <b style="color: red;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b> <b style="color: red;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: xx-small;">REVISED: Sunday, March 3, 2013</span></b></div> <br /> <div> <span class="Apple-style-span" style="font-weight: 800;"></span><br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2LQhECFH6vTZkQWViPC6HNpP5t3ldsfgaEkK7bdDXRTu7j3FMvYt_f2j3Ri5TIaUBfWWfmgHkYWUi20MWhys5h461YA9sNcKrueKytfsqdq4FWsIIg9DP6-3trRYd3hg3FR0oz3G-CnM/s1600/avatar.gif" imageanchor="1" style="font-weight: bold; margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2LQhECFH6vTZkQWViPC6HNpP5t3ldsfgaEkK7bdDXRTu7j3FMvYt_f2j3Ri5TIaUBfWWfmgHkYWUi20MWhys5h461YA9sNcKrueKytfsqdq4FWsIIg9DP6-3trRYd3hg3FR0oz3G-CnM/s1600/avatar.gif" /></a> </div> <br /> <br /> <div style="text-align: justify;"> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">Introduction to PostgreSQL. </span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><br /></span></b></div> <div> <b><span class="Apple-style-span" style="color: red; font-family: Verdana, sans-serif;">I. &nbsp;SQL INTRODUCTION</span></b></div> <div> <b><span class="Apple-style-span" style="color: blue; font-family: Verdana, sans-serif;"><br /></span></b> <b><span class="Apple-style-span" style="color: blue; font-family: Verdana, sans-serif;">A.&nbsp;&nbsp;PostgreSQL</span></b> </div> <br /> <div style="text-align: justify;"> <span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><b><span class="Apple-style-span" style="color: orange;">1. &nbsp;PostgreSQL Overview</span></b></span></div> <br /> <div style="text-align: justify;"> <span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><b><b>PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the&nbsp;</b><b>University of California at Berkeley Computer Science Department.</b></b></span></span></div> <br /> <div style="text-align: justify;"> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">PostgreSQL is an open-source descendant of the original Berkeley code.</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><br /></span></b></div> <div style="text-align: justify;"> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><b>PostgreSQL</b><b>&nbsp;supports a large part of the SQL standard and&nbsp;</b><b>offers many modern features, including:</b></span></b></div> <br /> <div> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">a.&nbsp;&nbsp;Complex Queries</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">b.&nbsp;&nbsp;Foreign Keys</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">c.&nbsp;&nbsp;Triggers</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">d.&nbsp;&nbsp;Views</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">e.&nbsp;&nbsp;Transactional Integrity</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">f.&nbsp;&nbsp;Multiversion Concurrency Control</span></b><br /> <br /></div> <div style="text-align: justify;"> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><b style="font-family: 'Times New Roman';"><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">PostgreSQL can be extended by the user by adding new:</span></b></span></b></div> <br /> <div> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">a.&nbsp;&nbsp;Data Types</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">b.&nbsp;&nbsp;Functions</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">c.&nbsp;&nbsp;Operators</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">d.&nbsp;&nbsp;Aggregate Functions</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">e.&nbsp;&nbsp;Index Methods</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">f.&nbsp;&nbsp;Procedural Languages</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"></span></b><br /></div> <div style="text-align: justify;"> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><b>PostgreSQL can be used, modified, and distributed by anyone free of charge for any&nbsp;</b><b>purpose.</b></span></b></div> <br /> <div style="text-align: justify;"> <span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><b>PostgreSQL is the most advanced open-source database available.</b></span></div> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><br /></span></b><b><span class="Apple-style-span" style="color: orange; font-family: Verdana, sans-serif;">2. &nbsp;PostgreSQL Download</span></b></div> <br /> <div style="text-align: justify;"> <span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><b>The <a href="http://postgresql.org/">PostgreSQL.org</a>&nbsp;download.&nbsp;</b></span></div> <br /> <b><span class="Apple-style-span" style="color: orange; font-family: Verdana, sans-serif;">3. &nbsp;PostgreSQL Wiki</span></b><br /> <div style="text-align: justify;"> <span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><b><br /></b></span> <span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><b>The&nbsp;<a href="http://wiki.postgresql.org/wiki/Main_Page">PostgreSQL.org wiki Main Page</a>&nbsp;provides community generated articles, guides and documentation.</b></span></div> <br /> <div> <b><span class="Apple-style-span" style="color: orange; font-family: Verdana, sans-serif;">4. &nbsp;Creating a PostgreSQL Database</span></b></div> <br /> <div> <span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><b><a href="http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/videos/how-create-postgres-database-using-pgadmin">How To Create a PostgreSQL Database Using pgAdmin III</a>&nbsp;will help you create a PostgreSQL Database.</b></span></div> <br /> <div style="text-align: justify;"> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">You have received an introduction to PostgreSQL, enjoy!</span></b><br /> <b><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><br /></span></b> <b style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 9px; text-align: left;"><span style="color: blue; font-family: Verdana, sans-serif;"><a href="http://goo.gl/qi5jw" style="color: #33aaff;">Elcric Otto Circle</a></span></b></div> <br /> <br /> <br /> <br /> <br /> <script type="text/javascript"> <!-- google_ad_client = "ca-pub-4871588942132101"; /* One */ google_ad_slot = "8813220342"; google_ad_width = 336; google_ad_height = 280; //</script> --&gt; <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> <br /> <br /> <br /> <br /> <br /> <script type="text/javascript"> <!-- google_ad_client = "ca-pub-4871588942132101"; /* Two */ google_ad_slot = "8243854886"; google_ad_width = 336; google_ad_height = 280; //</script> --&gt; <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> <br /> <br /> <br /> <br /> <br /> <script type="text/javascript"> <!-- google_ad_client = "ca-pub-4871588942132101"; /* Three */ google_ad_slot = "7921082405"; google_ad_width = 336; google_ad_height = 280; //</script> --&gt; <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> <br /> <br /> <br /> <br /> <br /> <div> <form> <span class="Apple-style-span" style="font-size: xx-small;"><input onclick="window.location.href='http://goo.gl/Hm4Lb'" type="BUTTON" value="HOME PAGE" /> </span> </form> </div> <br /> <br /> <br /> <br /> <br /> <div> <h1 style="text-align: center;"> <span style="color: red;">How to Link to My Home Page</span></h1> <form action="http://www.example.com/"> <label for="linkcode"> To link to "MY Home Page" from your website, simply copy and paste the following code into your website HTML page: </label> <textarea cols="43" id="linkcode" onclick="this.focus();this.select();" readonly="readonly" rows="5" title="Select the text here, click your right mouse button, click the Copy menu item, and paste it into your web page in HTML source mode"><p> <a href="http://goo.gl/Hm4Lb" target="_top">"Link to: ELCRIC OTTO CIRCLE's Home Page"</a></p> </textarea> </form> <b><span style="color: blue;">It will appear on your website as:</span></b><br /> <b><span style="color: blue;"><br /></span></b> <a href="http://goo.gl/Hm4Lb" target="_top">"Link to: ELCRIC OTTO CIRCLE's Home Page"</a> </div> <br /> <br /> <br /> <br /> <br /></div> http://sqlelcric.blogspot.com/2011/11/postgresql.htmlnoreply@blogger.com (Ron Tinnel)0