Skip to content
Search
DSL · Postgresql

from_pgsql_key_set

Definition

/**
 * Create a PostgreSQL extractor using keyset (cursor-based) pagination.
 *
 * More efficient than LIMIT/OFFSET for large datasets - uses indexed WHERE conditions
 * instead of skipping rows.
 *
 * @param Client $client PostgreSQL client
 * @param Sql|string $query SQL query to execute (must have ORDER BY matching keyset columns)
 * @param KeySet $keySet Columns to use for keyset pagination
 * @param list<mixed> $parameters Values bound by position to $1, $2, ... placeholders; wrap with {@see \Flow\PostgreSql\DSL\typed()} to force a specific PostgreSQL type
 */
from_pgsql_key_set(Client $client, Sql|string $query, KeySet $keySet, array $parameters) : PostgreSqlKeySetExtractor

Contributors

Built in the open.

Join us on GitHub
scroll back to top