Re: Create GLOBAL TABLE

From: Richard Huxton <dev(at)archonet(dot)com>
To: Marius Cornea <marius(at)tns-agb(dot)ro>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Create GLOBAL TABLE
Date: 2005-10-19 12:58:46
Message-ID: 43564306.4010706@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marius Cornea wrote:
> How can I make a global table (like pg_users, pg_shaddow) ?

You can't afaik. There are three things you can do though.

1. Anything you put into pg_template1 gets created in each new database
(unless you choose a different template when creating).
2. The dblink() module in contrib/ lets you connect two databases (on
the same or different clusters)
3. Use separate schemas rather than separate databases to split your data.

That any help?

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Davis 2005-10-19 13:01:12 Re: getting around---division by zero on numeric
Previous Message Patrick FICHE 2005-10-19 12:56:51 Re: getting around---division by zero on numeric