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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
