[SOLVED] Eloquent how I can parse postgresql's hstore?

Eloquent how I can parse postgresql's hstore?

An eloquent model uses the following table and it is stored in a postgresql database:

name: table
id: PK SERIAL
values: HSTORE

And the model is named TableModel

namespace App;
use Illuminate\Database\Eloquent\Model;
class TableModel extends Model
{
   protected $table = 'table';
}

But once I retrieve the value value I get the following response using tinker session:

$model = Model::find('1');
$model->value;
""name"=>"Namae", "value"=>"55""

How I can retrieve either the name or the value from the value column.

Solution

Hstore is simply a format in a form of

"key" => "Value","key"=>"value"

As seen in https://www.postgresql.org/docs/11/hstore.html

And easily can be converted into json by replacing the => into : and enclosing the string into {} a sample code to do this is (continuing the tinker session you mention in your question):

$value = $model->value;
$value = str_replace('=>',':',$value);
$value = '{'.$value.'}';
$value = json_decode($value)