This part describes the use of theSQL language inPostgres Pro. We start with describing the general syntax ofSQL, then explain how to create the structures to hold data, how to populate the database, and how to query it. The middle part lists the available data types and functions for use inSQL commands. The rest treats several aspects that are important for tuning a database for optimal performance.

The information in this part is arranged so that a novice user can follow it start to end to gain a full understanding of the topics without having to refer forward too many times. The chapters are intended to be self-contained, so that advanced users can read the chapters individually as they choose. The information in this part is presented in a narrative fashion in topical units. Readers looking for a complete description of a particular command should seePart VI.

Readers of this part should know how to connect to aPostgres Pro database and issueSQL commands. Readers that are unfamiliar with these issues are encouraged to readPart I first.SQL commands are typically entered using thePostgres Pro interactive terminalpsql, but other programs that have similar functionality can be used as well.