Inserting And Using A New Record In Postgres

A Problem Postgres Can Solve Easily Let’s say you need to insert a record into a table and then use that record immediately to push data into another table. This happens a lot with parent/child...

Using Custom Types in Postgres

Using Types For Fun and Profit In my last post about pulling documents from queries I showed an interesting way to return a result set using row_to_json to crunch down 1-many records into a JSON...

PostgreSQL Rising

Postgres.app Some buzz going around the web today about Postgres.app. Most people don’t understand why it’s interesting – so here’s a quick explanation. Postgres can be...