PostgreSQL

Topics: Database, Ruby on Rails

PostgreSQL stores structured data in relational tables; Rails code can query a sequence’s last_value without incrementing it.

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