PostgreSQL: Up and Running"O'Reilly Media, Inc.", 2012 - Всего страниц: 147 Thinking of migrating to PostgreSQL? This updated guide helps you quickly understand and use the 9.3 release of this open source database system. You ll not only learn about its unique enterprise-class features, but also discover that PostgeSQL is more than just a database system it s also an impressive application platform. Using numerous examples, this book shows you how to achieve tasks that are difficult or impossible in other databases. The second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. If you re an existing PostgreSQL user, you ll pick up gems you may have missed along the way.Learn basic administration tasks, such as role management, database creation, backup, and restoreApply the psql command-line utility and the pgAdmin graphical administration toolExplore PostgreSQL tables, constraints, and indexesLearn powerful SQL constructs not generally found in other databasesUse several different languages to write database functionsTune your queries to run as fast as your hardware will allowQuery external and variegated data sources with Foreign Data WrappersLearn how to replicate data, using built-in replication features" |
Содержание
Chapter 1 The Basics | 1 |
Chapter 2 Database Administration | 9 |
Chapter 3 psql | 31 |
Chapter 4 Using pgAdmin | 43 |
Chapter 5 Data Types | 59 |
Chapter 6 Of Tables Constraints and Indexes | 75 |
The PostgreSQL Way | 87 |
Chapter 8 Writing Functions | 101 |
Chapter 9 Query Performance Tuning | 113 |
Chapter 10 Replication and External Data | 125 |
Appendix Install Hosting and CommandLine Guides | 133 |