Полезная информация

...ORPORATION3.1
Ingres Corp. was later purchased by Computer Associates.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...ILLUSTRA3.2
Illustra was later purchased by Informix and integrated into Informix's Universal Server.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...cvs.3.3
cvs sychronizes access by developers to shared program files.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... C3.4
C is a popular computer language first developed in the 1970's.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... modules.3.5
All the files mentioned in this chapter are available as part of the POSTGRESQL distribution, or at http://www.postgresql.org/docs.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...FAQ3.6
Frequently Asked Questions
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...static3.7
A static function is a function that is used by only one program file.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...LINUX3.8
Linux is a popular UNIX-like, open source operating system.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... lowercase.4.1
A few operating systems are case-insensitive.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
....4.2
Don't be concerned about ?column?. We will cover that in section [*].
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...readline4.3
Readline is a GNU library that allows powerful command-line editing.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...'O''Donnell'.6.1
That is not a double qoute between the O and D. It is two single quotes.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... people.6.2
The <> means not equal.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...date6.3
This is the format generated by typing the command date at the UNIX command prompt.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... line.6.4
See section [*] for a full list of the psql backslash commands.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... command.6.5
Actually, POSTGRESQL regular expressions are like egrep extended regular expressions.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... this.6.6
Your site defaults may be different.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... tables.8.1
The process of distributing data across multiple tables to prevent redundancy is called data normalization.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...salesorder8.2
A table can not be called order. Order is a reserved keyword, for use in the ORDER BY clause. Reserved keywords are not available ble as table or column names.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... inserted.8.3
Technically, the column customer.customer_id is a primary key because it is the unique key for each customer row. The column salesorder.customer_id is a foreign key because it points to another table's primary key. This is covered in more detail in section [*].
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... validity8.4
The United States Postal Service has assigned a unique two-letter code to each U.S. state.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... join.8.5
Many database servers support a special type of join called an outer join that allows non-joined data to appear in the query. Unfortunately, POSTGRESQL does not support outer joins at this time.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...initdb9.1
See section [*] for a description of initdb.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... id.9.2
Technically, OID'S are unique among all databases sharing a common data directory tree.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... it.9.3
There are several other invisible columns. The POSTGRESQL manuals cover their meaning and use in detail.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
...OIDs.9.4
This is not completely true. 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.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
... execution.18.1
Here is how to set your default editor. At the operating system prompt, try typing:

EDITOR=vi

export EDITOR

This sets the default editor to vi. If that doesn't work, try:

setenv EDITOR vi
Do this at the operating system command prompt, not inside psql.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
Bruce Momjian
1999-11-21