![]() |
![]() |
Free Books / Computers / Practical PostgreSQL / | ![]() |
|
![]() |
||||
![]() |
![]() |
|||
![]() |
![]() |
|||
![]() |
||||
|
|
||||
![]() |
![]() |
|||
![]() |
Creating Tables with CREATE TABLE |
![]() |
||
![]() |
||||
![]() |
![]() |
![]() |
||
![]() |
||||
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:
postgresql, psql, relational database, sql, standard, query, programming, administration
![]() |
|
|