Sequel and Postgres array of enum

Question

I have enum_cars.

I have table user with column: own_cars: enum_cars[]

When I get User model and fetch own_cars field for instance, I have:

user.own_cars #=> "{Ford}" String

I connected

DB.extension :pg_array

and

Sequel.extension :pg_array

But this doesn't work for me. What I should do to fetch field as Array? Or it's impossible with enum array?

Are you asking how to store arrays in Postgres? Or are you not familiar with has_many? — Mark Thomas
– Mark Thomas, Commented Sep 30, 2017 at 20:29

QNester · Accepted Answer · 2017-10-03 08:34:39Z

1

Resolve this problem.

If you have in table array enum field u should registrate array type:

DB.extension :pg_array
DB.register_array_type(:enum_cars)

answered Oct 3, 2017 at 8:34

QNester

4814 silver badges9 bronze badges

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

1 Answer 1