pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Bhuvan A <bhuvansql@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: how can we get total records in pg server?
Date: Tue, 24 Jul 2001 08:30:12 -0700
Message-ID: <web-90463@davinci.ethosmedia.com> (raw)
In-Reply-To: <Pine.LNX.4.20.0107241859040.3133-100000@Larry.bks>

Bhuvan,

> the need is to get TOTAL RECORDS of all the THREE DATABASES or
> atleast
> TOTAL RECORDS of ONE DATABASE.

I guess that many of us are confused by your question.  The total
records in a table are easily counted -- just use count(*).  However, if
your database has many tables, what significance does totalling together
all of the records from those different tables have?  If I have a
reference list with 8 items, do I want to add it to a data table with
300,000 records to make 300,008?  No.

Further, PostgreSQL does not support multi-database operations of any
kind.  So if the data in those three databases needs to interact, you
should probably combine them into one database.

I can't help but feel that there are some basic database concepts you
haven't yet acquired.  Perhaps you've come to Postgres from Filemaker,
and are confused by the difference between "database" and "table".  If
so, you need to start with some basic education before proceeding on to
building a DB application.

In english, I would recommend: "PostgreSQL, Introduction and Concepts"
by Bruce Momjian, as well as "Database Design For Mere Mortals".  If you
would prefer another language, poll the list -- someone may be familiar
with other texts.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco







view thread (4+ messages)  latest in thread

Message-ID: <web-90463@davinci.ethosmedia.com>
Permalink:  ../web-90463@davinci.ethosmedia.com/
Also on:    postgresql.org/message-id/web-90463@davinci.ethosmedia.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: josh@agliodbs.com, bhuvansql@yahoo.com
  Subject: Re: how can we get total records in pg server?
  In-Reply-To: <web-90463@davinci.ethosmedia.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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