1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Chapter3.Advanced Features</title>
<link rel="stylesheet" href="stylesheet.css" type="text/css">
<link rev="made" href="pgsql-docs@postgresql.org">
<meta name="generator" content="DocBook XSL Stylesheets V1.70.0">
<link rel="start" href="index.html" title="PostgreSQL 8.1.4 Documentation">
<link rel="up" href="tutorial.html" title="PartI.Tutorial">
<link rel="prev" href="tutorial-delete.html" title="2.9.Deletions">
<link rel="next" href="tutorial-views.html" title="3.2.Views">
<link rel="copyright" href="ln-legalnotice.html" title="Legal Notice">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="chapter" lang="en" id="tutorial-advanced">
<div class="titlepage"><div><div><h2 class="title">
<a name="tutorial-advanced"></a>Chapter3.Advanced Features</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="sect1"><a href="tutorial-advanced.html#tutorial-advanced-intro">3.1. Introduction</a></span></dt>
<dt><span class="sect1"><a href="tutorial-views.html">3.2. Views</a></span></dt>
<dt><span class="sect1"><a href="tutorial-fk.html">3.3. Foreign Keys</a></span></dt>
<dt><span class="sect1"><a href="tutorial-transactions.html">3.4. Transactions</a></span></dt>
<dt><span class="sect1"><a href="tutorial-inheritance.html">3.5. Inheritance</a></span></dt>
<dt><span class="sect1"><a href="tutorial-conclusion.html">3.6. Conclusion</a></span></dt>
</dl>
</div>
<div class="sect1" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="tutorial-advanced-intro"></a>3.1.Introduction</h2></div></div></div>
<p> In the previous chapter we have covered the basics of using
<acronym class="acronym">SQL</acronym> to store and access your data in
<span class="productname">PostgreSQL</span>. We will now discuss some
more advanced features of <acronym class="acronym">SQL</acronym> that simplify
management and prevent loss or corruption of your data. Finally,
we will look at some <span class="productname">PostgreSQL</span>
extensions.
</p>
<p> This chapter will on occasion refer to examples found in <a href="tutorial-sql.html" title="Chapter2.The SQL Language">Chapter2, <i>The <acronym class="acronym">SQL</acronym> Language</i></a> to change or improve them, so it will be
of advantage if you have read that chapter. Some examples from
this chapter can also be found in
<code class="filename">advanced.sql</code> in the tutorial directory. This
file also contains some example data to load, which is not
repeated here. (Refer to <a href="tutorial-sql.html#tutorial-sql-intro" title="2.1.Introduction">Section2.1, “Introduction”</a> for
how to use the file.)
</p>
</div>
</div></body>
</html>
|
