PostgreSQL

Topics: Database, Ruby on Rails

PostgreSQL is an open-source relational database system.

Subtopics

• Install the pg gem in a Homebrew environment

Features

Sequences

Reading the last value of a sequence from Rails without incrementing it:

Website.connection.exec_query("SELECT last_value from site_no_seq").first

Utilities

• pgcopydb

Bookmarks

• PostgreSQL official website
• PostgreSQL Replication write-up

Related notes