Working with Ruby and Databases [PostgreSQL]

Question

I'm not versed working with DBs, but everytime I'm getting data from the DB with res = con.exec "SELECT * FROM #{table}" and then res.values I get all the values as if they were strings, for example:

[["1", "2017-01-14", "f"]]

Can I get Dates as Dates, integers as integers, etc.? or do I have to parse everything?

EDIT: I'm using Ruby without Rails.

Are you using Rails, or a database adapter like pg directly? — coreyward
– coreyward, Commented Jan 14, 2017 at 16:53
what database do you use, what type has your date in your database ? date or string ? — peter
– peter, Commented Jan 14, 2017 at 16:58
In the example that I shown it was INTEGER, DATE, BOOLEAN, but everything shows as string in Ruby and I use postgres. — Patricio S
– Patricio S, Commented Jan 14, 2017 at 16:59

coreyward · Accepted Answer · 2017-01-14 16:58:50Z

3

The documentation for the PG gem details how to handle basic typecasting:

conn.type_map_for_results = PG::BasicTypeMapForResults.new conn
conn.exec("select 1, now(), '{2,3}'::int[]").values
    # => [[1, 2014-09-21 20:51:56 +0200, [2, 3]]]

answered Jan 14, 2017 at 16:58

coreyward

80.5k21 gold badges148 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Working with Ruby and Databases [PostgreSQL]

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related