On Fri, Oct 08, 2004 at 11:21:25PM +0530, sreejith s wrote:
> How to get a the records returned by a sql executed within a pl/pgsql function
It's not clear what you're asking, but perhaps one of the following
pages will answer your question:
http://www.postgresql.org/docs/7.4/static/plpgsql-stat
>
> Hello list,
>
> Is there a system attribute or table or ? providing record count by table?
>
> Thanks.
>
pg_class.reltuples has the record count.
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
On Thu, Aug 29, 2002 at 13:37:40 -0500,
"Marie G. Tuite" <[EMAIL PROTECTED]> wrote:
>
> Is there a system attribute or table or ? providing record count by table?
No. Normally you use the count aggregate to obtain that information.
However if you do few updates and need this information fairl