[GENERAL] table size and storage location

2008-03-23 Thread chuckee
Hi, I have two questions: 1) how do I find out the size, in MB, of a particular table (called 'capture' in this case). I tried entering the SQL query SELECT (pg_tablespace_size('capture')); The result was the following: ERROR: tablespace "capture" does not exist 2) how do I find out where the a

Re: [GENERAL] table size and storage location

2008-03-25 Thread chuckee
paul rivers-2 wrote: > > chuckee wrote: >> 1) how do I find out the size, in MB, of a particular table (called >> 'capture' in this case). >> I tried entering the SQL query SELECT (pg_tablespace_size('capture')); >> The result was the followi