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 ===