An administrator is generally a person who is
in charge of installing and running the server. A user
could be anyone who is using, or wants to use, any part of the
PostgreSQL system. These terms should not
be interpreted too narrowly; this documentation set does not have fixed
presumptions about system administration procedures.
We use /usr/local/pgsql/ as the root
directory of the installation and /usr/local/pgsql/data
as the directory with the database files. These directories may vary
on your site, details can be derived in the Administrator's Guide.
In a command synopsis, brackets
([ and ]) indicate an optional phrase or keyword.
Anything in braces
({ and }) and containing vertical bars
(|)
indicates that you must choose one alternative.
Examples will show commands executed from various accounts and programs.
Commands executed from a Unix shell may be preceded with a dollar sign
("$"). Commands executed from particular user
accounts such as root or postgres are specially flagged and explained.
SQL commands may be preceded with
"=>"
or will have no leading prompt, depending on the context.
Note: The notation for
flagging commands is not universally consistent throughout the
documentation set.
Please report problems to the documentation mailing list
<pgsql-docs@postgresql.org>.
