1.The sintax for create table is :
CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
{ column_name data_type [ DEFAULT default_expr ] [ column_constraint [
... ] ] ...
What mean the parameter GLOBAL|LOCAL ??
2. in pg_class it is a field "relisshared" how can i use it ?
3.1 how can I use BKI script ?,
3.2 it is posible to modify postgres.bki to create another table with initdb
script ?
like: "create bootstrap shared_relation .." ?
----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
To: "Marius Cornea" <marius@tns-agb.ro>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, October 19, 2005 3:58 PM
Subject: Re: [GENERAL] Create GLOBAL TABLE
> 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
>