Migrating from Oracle: One word about pg_type
Here is some pg_type related trickery, which might be entertaining. A workaround for porting the pg_type table from Oracle to PostgreSQL.
Registering PostgreSQL as a service on Windows with pg_ctl
If you happen to run Windows, pg_ctl provides a nice way to register a PostgreSQL service. We show you how to do it right.
pg_service.conf: The forgotten config file
Configure services in a config file: pg_service.conf, and address them without having to worry about host, port, user and so on.
Permissions: A little trickery
Learn how to use the INHERIT keyword in PostgreSQL, which allows a role to inherit permissions from another role. There is a catch, however.
By coincidence I noticed that psql can produce perfect LaTeX code. How cool is that? We show you how to do it, with examples.
Flexible grouping: Some dirty SQL trickery
How to group PostgreSQL data with some dirty SQL trickery. Find the difference between timestamps; how to use flexible grouping.
Scaling PostgreSQL: Using more than just one core for aggregation
Unfortunately PostgreSQL cannot scale a single query to more than one core. We have done some experiments to see how scaling up can work.
Fuzzy search solves the problem of spelling errors in searches. The goal is really to make sure that users have a chance - even with typos.
JSON is used for configuration, data transfer, and a lot more. Luckily PostgreSQL is pretty good at it. Turn xlog into JSON.
In PostgreSQL all major DDLs (CREATE TABLE, ...) are fully transactional. However, there are some exceptions.
