Re: [GENERAL] Create GLOBAL TABLE

2005-10-24 Thread Marius Cornea
ginal Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: 20 October 2005 10:17 To: Marius Cornea Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Create GLOBAL TABLE Marius Cornea wrote: > 1.The sintax for create table is : >CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEM

Re: [GENERAL] Create GLOBAL TABLE

2005-10-20 Thread Richard Huxton
Marius Cornea wrote: 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 ?? http://www.postgresql.org/docs/8.0/stat

Re: [GENERAL] Create GLOBAL TABLE

2005-10-19 Thread Marius Cornea
ROTECTED]> Cc: 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

Re: [GENERAL] Create GLOBAL TABLE

2005-10-19 Thread Richard Huxton
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

[GENERAL] Create Global Table

2005-10-19 Thread Marius Cornea
how can i make a global table (like pg_users, pg_shaddow) ? Thx, Marius

[GENERAL] Create GLOBAL TABLE

2005-10-19 Thread Marius Cornea
How can I make a global table (like pg_users, pg_shaddow) ?   Thx, Marius