am 20.02.2006, um 19:39:55 +0200 mailte Andrus folgendes:
> When connectiong to database my application needs to determine how many
> connections is currently established to Postgres server.
select * from pg_stat_activity ;
> I can create temporary table at startup of each connection. But how to count
> the number of temporary tables created by all applications ?
Why do you need this information?
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===