Like all database systems, PostgreSQL lets you store data using a variety of different data types. These data types allow the database engine to optimise its use of memory and storage, and to perform operations on the stored data more efficiently and with fewer errors.Data type selection plays an important role in how efficiently your RDBMS functions, and so it’s important to be fully aware of the options available to you, and to select the most appropriate data type for your storage needs. That’s where this document comes in. It outlines the most important data types supported by PostgreSQL, describing when and how each should be used, and provides you with a ready supply of choices the next time you sit down to optimise your existing databases or create new ones.
Read more…

http://sqlzoo.net/为大家提供了一个交互式学习 SQL语句的平台，学习的内容包括：SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite 和 Access。

对某些SQL语句无法理解的朋友不妨试试这个网站。

值得一提的是，官方还提供了中文的镜像，镜像地址：http://vzoo.net/