This page in other versions: Unsupported versions: 6.3
PostgreSQL
Prev Chapter 13. The Query Language Next

Concepts

The fundamental notion in Postgres is that of a class, which is a named collection of object instances. Each instance has the same collection of named attributes, and each attribute is of a specific type. Furthermore, each instance has a permanent object identifier (OID) that is unique throughout the installation. Because SQL syntax refers to tables, we will use the terms table and class interchangeably. Likewise, an SQL row is an instance and SQL columns are attributes. As previously discussed, classes are grouped into databases, and a collection of databases managed by a single postmaster process constitutes an installation or site.


Prev Home Next
The Query Language Up Creating a New Class
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group