DZone, Inc. | www.dzone.com
By Leo Hsu and Regina Obe
About Postgresql
essential Postgresql
www.dzone.com Get More Refcardz! Visit refcardz.com
#71
Essential PostgreSQL
PostgreSQL is the world’s most advanced open source
database. It runs on numerous platforms: Linux, Unix,
Windows, Mac OSX. It is simple to install, fast, sports
enterprise features such as advanced spatial support via
PostGIS, windowing functions, and table partitioning. It
supports almost all SQL-92, SQL:1999, SQL:2003 and many
SQL:2006 and SQL:2008 standards. In addition to its enterprise
features, it has the added benefit of supporting numerous
languages for authoring stored functions and an extensible
procedural language architecture to introduce new languages.
Targeted at novices and professionals alike, this Refcard will
help you quickly navigate some of PostgreSQL’s most popular
features as well as its hidden gems. It will cover topics such
as configuration, administration, backup, language support,
and advanced SQL features. Items marked with [8.4] were
introduced in PostgreSQL 8.4.
CoNteNts INCluDe:
n About PostgreSQL
n Configuration
n Data Types
n Commonly Used Functions
n Database Objects
n Tools and more...
n Authoritative content
n Designed for developers
n Written by top experts
n Latest tools & technologies
n Hot tips & examples
n Bonus content online
n New issue every 1-2 weeks
Subscribe Now for FREE!
Refcardz.com
Get More Refcardz
(They’re free!)
Hot
Tip
All these can be edited with a text editor. They can
be edited via PgAdmin III if contrib/adminpack.sql is
installed in master postgres db.
CoNfIgurAtIoN
PostgreSQL uses three configuration files to control overall
operations. You can find these files in the initialized data
cluster (the folder specified during the initialization process
using initdb -d).
File
Purpose
postgresql.conf
Controls the listening port, IP, and default query planner settings,
memory settings, path settings, an