Support the ongoing development of Laravel.io →
Database Eloquent

Hello!

I'm using a postgresql DB and have a column containing arrays (integer[]). Problem is I don't know how to save or update data because of this array column.

I tried a simple

$table->column = [1, 2, 3];

But it doesn't work, I'm getting the following error :

preg_replace(): Parameter mismatch, pattern is a string while replacement is an array

Is there a way to make it work without using raw statements ?

Thank you

Last updated 3 years ago.
0

Could such data be better JSON encoded in the DB?

0

Yes, that would work in my case as I have access to the DB.

So I guess there's no easy way to store arrays with Eloquent other than converting the php array to postgresql array when inserting and the other way around when selecting.

Thanks

0

Sign in to participate in this thread!

Eventy

Your banner here too?

SynRJ synrj Joined 3 Sep 2014

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.