RE: Output a few tupels of 493033 tupels

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Hello,
>
> I have got a little problem with my datas. In one table I have
> got 493033 tupels. A simple Output of all datas is to much for
> the Browsers (and the intranet-connection) and to ask for all and
> then only give out a few is also a big problem for the server.
>
> Is there any way only to ask for some tupels in a
> postgres-database with PHP?
>
> H. Etzel

IIRC Postgres supports the limit and offset options on a select statements
so how about - for 100 rows starting at the first row...

select * from mytable limit 100, 0

Rich


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux