Text Size: Normal / Large

Home → Documentation → Manuals → PostgreSQL 8.0

PostgreSQL 8.0.19 Documentation
Prev	Fast Backward	Chapter 5. Data Definition	Fast Forward	Next

5.9. Other Database Objects

Tables are the central objects in a relational database structure, because they hold your data. But they are not the only objects that exist in a database. Many other kinds of objects can be created to make the use and management of the data more efficient or convenient. They are not discussed in this chapter, but we give you a list here so that you are aware of what is possible.

Views
Functions and operators
Data types and domains
Triggers and rewrite rules

Detailed information on these topics appears in Part V.

Prev	Home	Next
Schemas	Up	Dependency Tracking

User Comments

Tony Wasson <ajwasson AT gmail.com>

26 Sep 2005 22:31:22

It is also possible to set a search_path for a single user. You can do something like:

ALTER USER postgresql SET search_path TO foo,bar,public;

For this to work, the schemas must exist in the database you are connected to when running this command.

New comments cannot be added to old documentation versions.