This section is from the "Practical PostgreSQL" book, by John Worsley and Joshua Drake. Also available from Amazon: Practical PostgreSQL.
The SQL command to create a table is CREATE TABLE . This command requires, at minimum, a name for the new table, as well as a grouped description of each column name, and type. It also accepts several optional parameters; these include column constraints (which are rules on what data is or is not allowed within a column), and table constraints (general limitations and relationships defined on the table itself).
 
Continue to: