- Practical PostgreSQL
- A Note Regarding Supplemental Files
- Preface
- I. Introduction & Installation
- 1. What Is PostgreSQL?
- 2. Installing PostgreSQL
- Preparing for Installation
- 10 Steps to Installing PostgreSQL
- Step 1: Creating the “postgres” User
- Step 2: Installing the PostgreSQL Source Package
- Step 3: Configuring the Source Tree
- Step 4: Compiling the Source
- Step 5: Regression Testing
- Step 6: Installing Compiled Programs and Libraries
- Step 7: Setting Environment Variables
- Step 8: Initializing and Starting PostgreSQL
- Step 9: Configuring the PostgreSQL SysV Script
- Step 10: Creating a Database
- II. Using PostgreSQL
- 3. Understanding SQL
- Introduction to SQL
- Introduction to Relational Databases
- SQL Statements
- Data Types
- Tables in PostgreSQL
- 4. Using SQL with PostgreSQL
- Introduction to psql
- Using Tables
- Adding Data with INSERT and COPY
- Retrieving Rows with SELECT
- A Simple SELECT
- Specifying Target Columns
- Expressions, Constants, and Aliases
- Selecting Sources with the FROM Clause
- Aliasing FROM Sources
- Removing Duplicate Rows with DISTINCT
- Qualifying with the WHERE Clause
- Joining Data Sets with JOIN
- Grouping Rows with GROUP BY
- Sorting Rows with ORDER BY
- Setting Row Range with LIMIT and OFFSET
- Comparing Sets with UNION, INTERSECT and EXCEPT
- Using Case Expressions
- Creating Tables from Other Tables
- Modifying Rows with UPDATE
- Removing Rows with DELETE
- Using Sub-Queries
- Using Views
- Further SQL Application
- 5. Operators and Functions
- 6. PostgreSQL Clients
- 7. Advanced Features
- Indices
- Advanced Table Techniques
- Arrays
- Automating Common Routines
- Transactions and Cursors
- Extending PostgreSQL
- Creating New Functions
- Creating New Operators
- Creating an operator
- Overloading an operator
- Dropping an operator
- III. Administrating PostgreSQL
- 8. Authentication and Encryption
- 9. Database Management
- 10. User and Group Management
- IV. PostgreSQL Programming
- 11. PL/pgSQL
- 12. JDBC
- 13. LXP
- V. Command Reference
- 14. PostgreSQL Command Reference
- Abort
- Alter Group
- Alter Table
- Alter User
- Begin
- Close
- Cluster
- Comment
- Commit
- Copy
- Create Aggregate
- Create Database
- Create Function
- Create Group
- Create Index
- Create Language
- Create Operator
- Create Rule
- Create Sequence
- Create Table
- Create Table As
- Create Trigger
- Create Type
- Create User
- Create View
- Current_Date
- Current_Time
- Current_Timestamp
- Current_User
- Declare
- Delete
- Drop Aggregate
- Drop Database
- Drop Function
- Drop Group
- Drop Index
- Drop Language
- Drop Operator
- Drop Rule
- Drop Sequence
- Drop Table
- Drop Trigger
- Drop Type
- Drop User
- DROP VIEW
- End
- Explain
- FETCH
- Grant
- Insert
- Listen
- Load
- Lock
- Move
- Notify
- Reindex
- Reset
- Revoke
- Rollback
- Select
- Select Into
- Set
- Set Constraints
- Set Transaction
- Show
- Truncate
- Unlisten
- Update
- Vacuum
- A. Multibyte Encoding Types
- B. Backend Options for postgres
- C. Binary COPY Format
- D. Internal psql Variables
- 14. PostgreSQL Command Reference
- E. About the Authors
- Index
- Colophon
- Copyright
- 3. Understanding SQL
Colophon
Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects.
The animal on the cover of Practical PostgreSQL is a mammoth. Mammoths (of the genus Mammuthus) inhabited the Earth during the last Ice Age, which ended about 10,000 years ago. There are several types of mammoths, such as Colombian and Imperial, but the best known is the woolly mammoth. Mammoths resided on the tundra of Asia, Europe, and North America. They are believed to have migrated to North America over the Bering Strait land bridge.
Known for their large size, mammoths ranged from 12 to 15 feet tall at the shoulder and weighed as much as 6 to 8 tons. They had long, dense hair and under fur, long trunks, and large ears. Their most prominent features were long, curved tusks that measured up to 16 feet. Mammoths used their tusks for digging underneath the snow to find food, for protection, and in mating rituals. As herbivores, they ate leaves of willow, hornbeam, fir, hazel, and alden. They lived up to 60 years in age. Scientists attribute the mammoths’ extinction to the climate changes that ended the Ice Age.
Sarah Jane Shangraw and Jeff Holcomb were the copyeditors for Practical PostgreSQL. Jane Ellin provided quality control.
Ellie Volckhausen designed the cover of this book, based on a series design by Edie Freedman. The cover image is a 19th-century engraving from the Dover Pictorial Archive. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe’s ITC Garamond font.
The print version of this book was created by translating the DocBook XML markup of its source files into a set of gtroff macros using a filter developed at O’Reilly & Associates by Norman Walsh. Steve Talbott designed and wrote the underlying macro set on the basis of the GNU troff–gs macros; Lenny Muellner adapted them to XML and implemented the book design. The text and heading fonts are ITC Garamond Light and Garamond Book; the code font is Constant Willison. This colophon was written by Linley Dolby.
Whenever possible, our books use a durable and flexible lay-flat binding.
-
No Comment