PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database

PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database


Thinking of migrating to PostgreSQL? This transparent, fast paced advent is helping you recognize and use this open resource database method. not just will you find out about the company type gains in models 9.2, 9.3, and 9.4, you will additionally realize that PostgeSQL is greater than a database system--it's additionally a powerful software platform.
With examples all through, this publication exhibits you ways to accomplish initiatives which are tough or very unlikely in different databases. This moment version covers LATERAL queries, augmented JSON help, materialized perspectives, and different key issues. in case you are a present PostgreSQL person, you will decide up gemstones you might have neglected before.
  • Learn easy management initiatives akin to position administration, database production, backup, and restore
  • Apply the psql command-line software and the pgAdmin graphical management tool
  • Explore PostgreSQL tables, constraints, and indexes
  • Learn strong SQL constructs now not in general present in different databases
  • Use a number of diverse languages to write down database functions
  • Tune your queries to run as speedy as your will allow
  • Query exterior and variegated info assets with international information wrappers
  • Learn tips on how to use integrated replication beneficial properties to duplicate data

Show sample text content

Download sample