Shroff Publishers & Distributors Pvt Ltd
|Number of Pages
Computer And Internet
If youre thinking about migrating to the PostgreSQL open sourcedatabase system, this guide provides a concise overview to help youquickly understand and use PostgreSQLs unique features. Not onlywill you learn about the enterprise class features in the 9.2release, youll also discover that PostgeSQL is more than just adatabase system-its also an impressive application platform.
With numerous examples throughout this book, youll learn how toachieve tasks that are difficult or impossible in other databases.If youre an existing PostgreSQL user, youll pick up gems you mayhave missed along the way.
Learn basic administration tasks, such as role management,database creation, backup, and restore
Apply the psql command-line utility and the pgAdmin graphicaladministration tool
Explore PostgreSQL tables, constraints, and indexes
Learn powerful SQL constructs not generally found in otherdatabases
Use several different languages to write database functions
Tune your queries to run as fast as your hardware will allow
Query external and variegated data sources with Foreign DataWrappers
Learn how to replicate data, using built-in replicationfeatures
Chapter 1 The Basics
Chapter 2 Database Administration
Chapter 3 psql
Chapter 4 Using pgAdmin
Chapter 5 Data Types
Chapter 6 of Tables, Constraints, and Indexes
Chapter 7 SQL: The PostgreSQL Way
Chapter 8 Writing Functions
Chapter 9 Query Performance Tuning
Chapter 10 Replication and External Data
Appendix Install, Hosting, and Command-Line Guides
About the Authors: Regina Obe, Leo Hsu
Regina Obe is a co-principal of Paragon Corporation, a databaseconsulting company based in Boston. She has over 15 years ofprofessional experience in various programming languages anddatabase systems, with special focus on spatial databases. She is amember of the PostGIS steering committee and the PostGIS coredevelopment team. Regina holds a BS degree in mechanicalengineering from the Massachusetts Institute of Technology. Sheco-authored PostGIS in Action.
Leo Hsu is a co-principal of Paragon Corporation, a databaseconsulting company based in Boston. He has over 15 years ofprofessional experience developing and thinking about databases fororganizations large and small. Leo holds an MS degree inengineering of economic systems from Stanford University and BSdegrees in mechanical engineering and economics from theMassachusetts Institute of Technology. He co-authored PostGIS inAction.