Re: Create GLOBAL TABLE
От | Marius Cornea |
---|---|
Тема | Re: Create GLOBAL TABLE |
Дата | |
Msg-id | 002e01c5d4ef$db7976d0$5a45a8c0@mariushome обсуждение исходный текст |
Ответ на | Create GLOBAL TABLE ("Marius Cornea" <marius@tns-agb.ro>) |
Ответы |
Re: Create GLOBAL TABLE
|
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: