...tex2html_comment_mark^5.1

Ingres Corporation was later purchased by Computer Associates.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

... ^5.2

Illustra was later purchased by Informix and integrated into Informix 's Universal Server.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...cvs. ^5.3

cvs sychronizes access by developers to shared program files.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^5.4

C is a popular computer language first developed in the 1970s.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^5.5

All the files mentioned in this chapter are available as part of the POSTGRESQL distribution, or at http://www.postgresql.org/docs.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...FAQ, ^5.6

Frequently Asked Questions

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...static ^5.7

A static function is used by only one program file.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

... ^5.8

Linux is a popular UNIX-like, open source operating system.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^6.1

A few operating systems are case-insensitive.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^6.2

Don't be concerned about ?column?. We will cover that in Section .

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...readline ^6.3

Readline is an open source library that allows powerful command-line editing.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...age. ^7.1

In a real-world database, the person's birth date would be stored and not the person's age. The age must be updated each time the person has a birthday. A person's age can be computed when needed from a birth date field.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^7.2

A character string is a group of characters strung together.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^8.1

See Section  for a full list of the psql backslash commands.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...'O''Donnell'. ^8.2

That is not a double quote between the O and D, but rather two single quotes.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^8.3

The <> means not equal.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^8.4

Actually, in POSTGRESQL, regular expressions are like egrep extended regular expressions.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^8.5

Your site defaults may be different.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^10.1

In the real world, the name columns would be much longer, perhaps CHAR(60) or CHAR(180). You should base the length on the longest name you may ever wish to store. Short names are used here so they display properly in the examples.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...salesorder ^10.2

A table cannot be called order. The word order is a reserved keyword, for use in the ORDER BY clause. Reserved keywords are not available as table or column names.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^10.3

The United States Postal Service has assigned a unique two-letter code to each U.S. state.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^10.4

In our example, changing part.price would change the price on previous orders of the part, which would cause problems. In the real world, we would need a partprice table to store the part number, price, and effective date for the price.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^11.1

See Appendix  for a description of initdb.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^11.2

Values less than this are reserved for internal use.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...ID. ^11.3

Technically, OID's are unique among all databases sharing a common /data directory tree.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^11.4

Several other invisible columns exist as well. The POSTGRESQL manuals cover their meaning and use.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...OIDs. ^11.5

This is not completely accurate. Gaps can occur if a query is assigned a sequence number as part of an aborted transaction. See Section  for a description of aborted transactions.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...tex2html_comment_mark^11.6

Tables can be configured to share sequence counters, if desired.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

...cat ^19.1

Non-Unix operating system users would use the type command.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

... ^19.2

The sed  operating system command replaces one string with another. See the sed(1) manual page for more information.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.... ^23.1

Some operating systems may use gmake rather than make . Also, some operating systems will use regress.o rather than regress.so.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.