We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

Postgresql HStore support

is hstore supported? I can't seem to find any documentation from Phalcon about it.



98.9k
edited Oct '14

You can use the database component to access your hstore attributes:

$sql    = "SELECT books->'name' as book FROM books WHERE book->'year'= 2011";
$result = $connection->query($sql);

https://docs.phalcon.io/en/latest/reference/db.html