By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

Limitation in query result from postgresql table

P: 3
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
Aug 29 '06 #1
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

Try with the command TOP

SELECT TOP 1000 Field1, Field2
FROM My_table;

Best regards!

:)
Sep 10 '06 #2

PEB
Expert 100+
P: 1,418
PEB
Try also

SELECT * FROM YourTable Limit 1000;
Sep 10 '06 #3

P: 3
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.
Sep 28 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.