Re: Create GLOBAL TABLE - Mailing list pgsql-general

From Richard Huxton
Subject Re: Create GLOBAL TABLE
Date
Msg-id 43564306.4010706@archonet.com
Whole thread Raw
In response to Create GLOBAL TABLE  ("Marius Cornea" <marius@tns-agb.ro>)
List 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

pgsql-general by date:

Previous
From: Patrick FICHE
Date:
Subject: Re: getting around---division by zero on numeric
Next
From: Sean Davis
Date:
Subject: Re: getting around---division by zero on numeric