In the previous chapter we have covered the basics of using SQL to store and access your data in PostgreSQL. We will now discuss some more advanced features of SQL that simplify management and prevent loss or corruption of your data. Finally, we will look at some PostgreSQL extensions.
This chapter will on occasion refer to examples found in
Chapter 2 to
change or improve them, so it will be useful to have read that
chapter. Some examples from this chapter can also be found in
advanced.sql in the tutorial
directory. This file also contains some sample data to load, which
is not repeated here. (Refer to Section 2.1 for how to use the
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.