Unbuffered queries using Postgres+PHP?

Question

Is there a way to execute unbuffered queries against PostgresSQL from PHP, or at least limit the size of the local buffer that a driver uses?

Answer 1

Hmmm... I found a PHP class belonging to the Flourish (un-)framework, that seems to have a function that could suit your needs.

Answer 2

Unfortunately there is not an unbuffered mode for the PHP pgsql extension or the pdo_pgsql extension. Flourish has an unbufferedQuery() method for fDatabase, but for PostgreSQL databases it uses the normal query functionality of the extensions.