Ruby 中 Postgres 查询的简单示例

发布于01月14日

就我的一生而言，我找不到一个简单的例子，仅仅运行这样的东西

"SELECT * FROM MyTable"

用Ruby 做的.我发现的所有东西都假设是ORM或Rails.现在，我不想要ORM；我不要铁轨.我正在寻找使用pg gem并执行简单查询的独立程序.

推荐答案

来自pg gem文档(http://rubydoc.info/gems/pg/0.10.0/frames)

require 'pg'
conn = PGconn.open(:dbname => 'test')
res  = conn.exec('SELECT 1 AS a, 2 AS b, NULL AS c')
res.getvalue(0,0) # '1'
res[0]['b']       # '2'
res[0]['c']       # nil

My next question would be authentication with a DB that requires a password. Looks like you can send a connection string like this:
PGconn.connect( "dbname=test password=mypass") or use the constuctor with parameters:
PGconn.new(host, port, options, tty, dbname, login, password) or use a hash like :password => '...' see here for all available options.