query postgresql array column

Question

I couldn't convert postgresql array to php array. Here is my array column is character varying[] and here are the values {image1,image2,image3}

$imgArry always null.

$query = "SELECT \"A\".\"id\",
                array_to_json(\"A\".images)
                 FROM 
                public.A " ;

    $rs = pg_query($db, $query) or
            die("Cannot execute query: $query\n");
    $index = 0;
    while ($row = pg_fetch_assoc($rs)) {
        $A->id = $row["id"];

        $imgArry = json_decode($row["images"]);
        $planproduct->image=$imgArry[0];

user1688346 · Accepted Answer · 2013-06-24 19:24:36Z

1

This does it.

 preg_match('/^{(.*)}$/', $row["images"], $matches);
 $imgArry=str_getcsv($matches[1]);

answered Jun 24, 2013 at 19:24

user1688346

1,9805 gold badges26 silver badges50 bronze badges

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

1 Comment

greg Over a year ago

This is not immuned to slashed expressions. str_getcsv(str_replace('\\\\', '\\', trim($data, "{}")))) is.

Collectives™ on Stack Overflow

query postgresql array column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related