Pg is the Ruby interface to the {PostgreSQL RDBMS}[http://www.postgresql.org/]. It works with {PostgreSQL 8.3 and later}[http://bit.ly/6AfPhm]. A small example usage: #!/usr/bin/env ruby require 'pg' # Output a table of current connections to the DB conn = PG.connect( dbname: 'sales' ) conn.exec( "SELECT * FROM pg_stat_activity" ) do |result| puts " PID | User | Query" result.each do |row| puts " %7d | %-16s | %s " % row.values_at('procpid', 'usename', 'current_query') end end
Required Ruby Version
>= 1.8.7
Authors
Michael Granger
Versions
- 1.6.3 December 29, 2025 (220 KB)
- 1.6.3 December 29, 2025 arm64-darwin (3.95 MB)
- 1.6.3 December 29, 2025 x86_64-darwin (3.56 MB)
- 1.6.3 December 29, 2025 aarch64-linux-musl (4.16 MB)
- 1.6.3 December 29, 2025 aarch64-linux (4.2 MB)
- 0.15.0 March 26, 2013 x86-mingw32 (3.41 MB)