>
> I am using Java language for getting first 10 records from the table
in postgres.
> I dont know how to fetch 10 records from the table.
> Raj
>
First answer is RTFM. But within psql you can fetch like this:
begin;
declare fu cursor for select * from foo;
fetch 10 in fu;
fetch 10 in fu;
...
close fu;
end;
Does this answer your question?
Regards, Christoph