Appendix D. PostgreSQL features

In this appendix, we cover features and behaviors that are fairly distinctive to PostgreSQL, which make it a little different from working with other relational databases.

Useful PostgreSQL resources

Below you’ll find a list of key PostgreSQL resources that cover general PostgreSQL usage in addition to resources for add-on tools and performance.

General

Connecting to a PostgreSQL server

Controlling access to data

Backup and restore

Data structures and objects

Writing functions in SQL

Writing functions in PL/PgSQL

Performance

Summary