showing X fields from X total - Mailing list pgsql-general

hi,
    i have posgresql 6.4 and jdbc6.4.
    i am making a query returning like 6000 registers. I would like to
restrict the query in order to show the result 100 by 100 registers.
    how can i make that SQL query?

        if i make "  select * from files order by (name)";

thanks in advance,

marcos

--
m a r c o s @ i v a l . e s