[GENERAL] Newbie questions (pg_global, tablespace, pg_temp, ...)

2007-01-17 Thread Alexi Gen
Hello, I'm new to postgreSQL (not databases) and trying to find my way arouund. Have a couple of questions: (a) In which dir is the pg_global stored? Is it "C:\Program Files\PostgreSQL\8.2\data\global"? (b) Why is the pg_tablespace.spclocation column=null for pg_default & pg_global? (c) When

Re: [GENERAL] Newbie questions (pg_global, tablespace, pg_temp, ...)

2007-01-17 Thread Martijn van Oosterhout
On Wed, Jan 17, 2007 at 07:02:13PM +0530, Alexi Gen wrote: > Hello, > > I'm new to postgreSQL (not databases) and trying to find my way arouund. > Have a couple of questions: > > (a) In which dir is the pg_global stored? > Is it "C:\Program Files\PostgreSQL\8.2\data\global"? Yes. > (b) Why is t

[GENERAL] Newbie questions (pg_global, tablespace, pg_temp, ...)

2007-01-17 Thread Alexi Gen
Hello, I'm new to postgreSQL (not databases) and trying to find my way arouund. Have a couple of questions: (a) In which dir is the pg_global stored? Is it "C:\Program Files\PostgreSQL\8.2\data\global"? (b) Why is the pg_tablespace.spclocation column=null for pg_default & pg_global? (c) When