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 following: ERROR: tablespace capture does not exist You're

[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