O'Reilly Media book: PostgreSQL: Up and Running

PostgreSQL: Up and Running:
If you’re thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL’s unique features. Not only will you learn about the enterprise class features in the 9.2 release, you’ll also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform. With numerous examples throughout this book, you’ll learn how to achieve tasks that are difficult or impossible in other databases.

PostgreSQL 9.1 with synchronous replication - The H Open Source: News and Features

PostgreSQL 9.1 with synchronous replication - The H Open Source: News and Features: The recently published version 9.1 of PostgreSQL, a free SQL database, mainly improves replication

Beginning Databases with PostgreSQL - PostgreSQL - Databases

Beginning Databases with PostgreSQL - PostgreSQL - Databases

I already registered "my" dead-tree book with them, therefore I can purchase the e-book for USD 10.

SQL: Limiting the Number of Rows Returned

SQL Cookbook - O'Reilly Media

Chapter 1 Retrieving Records: Limiting the Number of Rows Returned.

Problem

You want to limit the number of rows returned in your query. You are not concerned with the order; any n rows will do.

Solution

Use the built-in function provided by your database to control the number of rows returned.

DB2

…

MySQL and PostgreSQL

Do the same thing in MySQL and PostgreSQL using LIMIT:

select * from emp limit 5

Oracle

…

SQL Server

…

Discussion

…

PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: LIMIT and OFFSET

PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: LIMIT and OFFSET:

"LIMIT and OFFSET allow you to retrieve just a portion of the rows that are generated by the rest of the query"

jdbc.postgresql.org : getConnection : various properties resp. parameters

Connecting to the Database


Q: how to pass connection parameters via getConnection? which ones are there?
A: …?

Who knows?

PostgreSQL: Manuals

PostgreSQL: Manuals

Maybe you appreciate the variants with user comments, or maybe you want to submit a comment yourself.

PostgreSQL: the function date_trunc is conceptually similar to the trunc function for numbers

PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: Date/Time Functions and Operators

pgAdmin: PostgreSQL administration and management tools

pgAdmin: PostgreSQL administration and management tools

PostgreSQL: The world's most advanced open source database

PostgreSQL: The world's most advanced open source database