Skip site navigation (1) Skip section navigation (2)

Re: ruby/postgres - getting assoc array of rows?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: ruby/postgres - getting assoc array of rows?
Date: 2005-11-20 05:32:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
On Sat, Nov 19, 2005 at 08:14:40PM -0800, CSN wrote:
> Looking at the docs here:
> there doesn't appear to be an easy way to get an associative row
> of rows returns.

What exactly are you looking for?  The example you posted returns
an array of hashes, but depending on what you're doing all that
work might not be necessary.  PGconn#exec returns a PGresult object,
the PGresult#each iterator yields PGrow objects, and PGrow#[] accepts
both numeric and text indexes.  Example:

% psql -d test -c 'SELECT id, name FROM people'
 id | name  
  1 | Alice
(1 row)

% cat test.rb
require 'postgres'
conn ='dbname=test')
res = conn.exec('SELECT id, name FROM people')
res.each do |row|
  puts "by name:     #{row['id']} #{row['name']}"
  puts "by position: #{row[0]} #{row[1]}"

% ruby test.rb
by name:     1 Alice
by position: 1 Alice

You could also convert the PGresult object into an array of PGrow
objects with a one-liner, although you wouldn't get automatic bytea
handling as in the function you posted:

rows = res.collect

Will any of this work for you?  If not then please provide more

Michael Fuhr

In response to


pgsql-interfaces by date

Next:From: Michael FuhrDate: 2005-11-20 05:52:27
Subject: Re: ruby/postgres - getting assoc array of rows?
Previous:From: CSNDate: 2005-11-20 04:14:40
Subject: ruby/postgres - getting assoc array of rows?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group