pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedrecord count
5+ messages / 5 participants
[nested] [flat]
* record count
@ 2002-08-29 18:37 Marie G. Tuite <marie.tuite@edisonaffiliates.com>
0 siblings, 2 replies; 5+ messages in thread
From: Marie G. Tuite @ 2002-08-29 18:37 UTC (permalink / raw)
To: pgsql-sql
Hello list,
Is there a system attribute or table or ? providing record count by table?
Thanks.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: record count
@ 2002-08-29 19:06 Bruno Wolff III <bruno@wolff.to>
parent: Marie G. Tuite <marie.tuite@edisonaffiliates.com>
1 sibling, 0 replies; 5+ messages in thread
From: Bruno Wolff III @ 2002-08-29 19:06 UTC (permalink / raw)
To: Marie G. Tuite <marie.tuite@edisonaffiliates.com>; +Cc: pgsql-sql
On Thu, Aug 29, 2002 at 13:37:40 -0500,
"Marie G. Tuite" <marie.tuite@edisonaffiliates.com> 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 fairly often,
then you may want to keep the data in your own table using triggers.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: record count
@ 2002-08-30 05:31 Bhuvan A <bhuvansql@linuxfreemail.com>
parent: Marie G. Tuite <marie.tuite@edisonaffiliates.com>
1 sibling, 0 replies; 5+ messages in thread
From: Bhuvan A @ 2002-08-30 05:31 UTC (permalink / raw)
To: pgsql-sql
>
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Record Count
@ 2004-10-08 17:51 sreejith s <getsreejith@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: sreejith s @ 2004-10-08 17:51 UTC (permalink / raw)
To: pgsql-sql
Friends,
How to get a the records returned by a sql executed within a pl/pgsql function
Sreejith
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Record Count
@ 2004-10-08 19:32 Michael Fuhr <mike@fuhr.org>
parent: sreejith s <getsreejith@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Michael Fuhr @ 2004-10-08 19:32 UTC (permalink / raw)
To: sreejith s <getsreejith@gmail.com>; +Cc: pgsql-sql
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-statements.html#PLPGSQL-SELECT-INTO
http://www.postgresql.org/docs/7.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
http://www.postgresql.org/docs/7.4/static/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING
If you still have trouble, please post more info about what you're
trying to do.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-10-08 19:32 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-08-29 18:37 record count Marie G. Tuite <marie.tuite@edisonaffiliates.com>
2002-08-29 19:06 ` Bruno Wolff III <bruno@wolff.to>
2002-08-30 05:31 ` Bhuvan A <bhuvansql@linuxfreemail.com>
2004-10-08 17:51 Record Count sreejith s <getsreejith@gmail.com>
2004-10-08 19:32 ` Re: Record Count Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox