This page in other versions: Unsupported versions: 6.5 / 7.0


"..." or /usr/local/pgsql/ at the front of a file name is used to represent the path to the Postgres superuser's home directory.

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.

In examples, parentheses ("(" and ")") are used to group boolean expressions. "|" is the boolean operator OR.

Examples will show commands executed from various accounts and programs. Commands executed from the root account will be preceeded with ">". Commands executed from the Postgres superuser account will be preceeded with "%", while commands executed from an unprivileged user's account will be preceeded with "$". SQL commands will be preceeded with "=>" or will have no leading prompt, depending on the context.

Note: At the time of writing (Postgres v7.0) the notation for flagging commands is not universally consistant throughout the documentation set. Please report problems to the Documentation Mailing List.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group