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" <[EMAIL PROTECTED]>
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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
