Description:
If you think about migrating to open source system PostgreSQL database, this guide provides a brief overview to help you quickly understand and use the unique features of PostgreSQL. Not only will you learn about enterprise-class features in release 9.2, you will discover that PostgeSQL is more than just a system database platform is also an impressive program.
With numerous examples throughout the book, you will learn how to perform tasks that are difficult or impossible on the basis of other data to arrive. If you have an existing PostgreSQL user, you will pick up gems, you can get lost along the way.
- Here are the basic administrative tasks such as role, database creation, backup and restore
- Services match the psql command-line and graphical administration tool pgAdmin
- Investigation of PostgreSQL tables, constraints, and indexes
- Learn powerful SQL constructs that are not common in databases other
- Use different language to write database functions
- Do you have questions run as fast as your hardware will allow
- Query external data sources and data wrappers contaminated with foreign
- Learn how to replicate data using the built in replication features
Content
Chapter 1. the basics
Chapter 2. Administration database
Chapter 3. psql
Chapter 4. using pgAdmin
Chapter 5. data types
Chapter 6. Tables, constraints, and indexes
Chapter 7. SQL: PostgreSQL Street
Chapter 8. write functions
Chapter 9. Query Performance Tuning
Chapter 10. Replication and remote data
Hours. Installation, hosting, and Command-Line Guides
