Received: from Donald.bks ([203.145.133.16]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6ODaDf07688 for ; Tue, 24 Jul 2001 09:36:16 -0400 (EDT) (envelope-from bhuvansql@yahoo.com) Received: from Larry.bks (root@Larry.bks [200.2.1.10]) by Donald.bks (8.11.2/8.11.2) with ESMTP id f6ODYTO14277; Tue, 24 Jul 2001 19:04:29 +0530 Received: from localhost (bhuvan@localhost) by Larry.bks (8.9.3/8.8.5) with ESMTP id TAA09534; Tue, 24 Jul 2001 19:03:55 +0530 X-Authentication-Warning: Larry.bks: bhuvan owned process doing -bs Date: Tue, 24 Jul 2001 19:03:55 +0530 (IST) From: Bhuvan A X-Sender: bhuvan@Larry.bks To: omid omoomi cc: pgsql-sql@postgresql.org Subject: Re: how can we get total records in pg server? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200107/322 X-Sequence-Number: 4135 hi all, consider the pg server with databases bhuvan uday guru the need is to get TOTAL RECORDS of all the THREE DATABASES or atleast TOTAL RECORDS of ONE DATABASE. Seems to be simple. Thankx in advance and infact i was a newbie. Regards, Bhuvaneswar. ================================================================================ "There is nothing new under the sun, but there are lots of old things we don't know yet." -Ambrose Bierce ================================================================================ On Mon, 23 Jul 2001, omid omoomi wrote: > you mean this ? > select count(*) from tablefoo; > > > >From: Bhuvan A > >To: pgsql-sql@postgresql.org > >Subject: [SQL] how can we get total records in pg server? > >Date: Mon, 23 Jul 2001 20:03:42 +0530 (IST) > > > > > >Hi all, > > > >how can we get the COUNT of total records in the db server? > > > >hope this could be simple for pg experts. > >thankx in advance! > > > >Regards, > >Bhuvaneswar. > >================================================================================ > > Eighty percent of married men cheat in America. The rest cheat in > >Europe. > > -- Jackie Mason > >================================================================================ > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 3: if posting/reading through Usenet, please send an appropriate > >subscribe-nomail command to majordomo@postgresql.org so that your > >message can get through to the mailing list cleanly > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp >