Limitation in query result from postgresql table

Hi
Is there any limitation in query result in postgresql?
When I run the query , I only can see maximum 1000 records(rows).
Actually the results should be more than 1000.

I appreciate the reply.
Thanks and Regards.
vivian

re: Limitation in query result from postgresql table

Hi,

Try with the command TOP

SELECT TOP 1000 Field1, Field2
FROM My_table;

Best regards!

:)

re: Limitation in query result from postgresql table

Try also

SELECT * FROM YourTable Limit 1000;

re: Limitation in query result from postgresql table

Thank you so much,
Actually my problem is that the query results come out 1000 rows only even I didn't set any limitation.
I want all of the results (more than 1000).
But the system only show 1000 rows.
I dont want 1000 rows, I want more than 1000. The correct result is 1400 rows.
pls guide me.

Thank you .
vivian.