Summary
In this chapter, you learned about the many ingredients that go into designing a PostgreSQL database. The chapter began with an overview of some helpful commands for dealing with databases, schemas, and tables. This discussion was followed by an introduction to PostgreSQL’s supported datatypes, offering information about the name, purpose, and range of each. The chapter then examined many of the most commonly used attributes, which serve to further tweak column behavior. The chapter concluded with a discussion of how to make use of more advanced datatype objects, including composite datatypes and domains, to help simplify datatype management.
In the next chapter, we’ll dive into another key PostgreSQL feature: security. You’ll learn all about PostgreSQL’s powerful authentication system, as well as learn more about how to secure the PostgreSQL server and create secure PostgreSQL connections using SSL.
Access provided by Autonomous University of Puebla. Download to read the full chapter text
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Rights and permissions
Copyright information
© 2006 W. Jason Gilmore
About this chapter
Cite this chapter
(2006). From Databases to Datatypes. In: Beginning PHP and PostgreSQL 8. Apress. https://doi.org/10.1007/978-1-4302-0136-6_28
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0136-6_28
Publisher Name: Apress
Print ISBN: 978-1-59059-547-3
Online ISBN: 978-1-4302-0136-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books