Re: Limiting number of records to show.

Thanx for the fast response!

Can I apply this to a user profile?
If my users type SELECT * FROM table... they should see only 1000 records...

Thanx!

Duncan Adams (DNS) wrote:

>u could use.
>
>select * from <table> limit 1000 offset 2000;
>
>-----Original Message-----
>From: Wim [mailto:wdh(at)belbone(dot)be]
>Sent: Friday, May 03, 2002 10:47 AM
>To: pgsql-novice(at)postgresql(dot)org
>Subject: [NOVICE] Limiting number of records to show.
>
>
>Hello,
>
>I have a table with over 1.000.000 records. I'd like to limit the
>maximum number of records to display, so if one my users opens the whole
>table, he will see only for example 1000 records.
>If I don't limit and they open the whole table, the server's CPU-load
>raises to 150...
>I searched the docs, but couldn't find the info....
>
>Is this possible? If yes, how do I do this?
>
>Thanx!
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>