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

Re: [GENERAL] table size and storage location

2008-03-25 Thread paul rivers
chuckee wrote: 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

Re: [GENERAL] table size and storage location

2008-03-25 Thread Andrej Ricnik-Bay
On 25/03/2008, chuckee [EMAIL PROTECTED] wrote: Thanks but I still get the error 'ERROR: relation capture does not exist' when trying these two alternative functions you mention above. There is definitely a table called 'capture' in my database! Are you sure you're connected to the right

Re: [GENERAL] table size and storage location

2008-03-25 Thread Tom Lane
Andrej Ricnik-Bay [EMAIL PROTECTED] writes: On 25/03/2008, chuckee [EMAIL PROTECTED] wrote: Thanks but I still get the error 'ERROR: relation capture does not exist' when trying these two alternative functions you mention above. There is definitely a table called 'capture' in my database!

[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

Re: [GENERAL] table size and storage location

2008-03-23 Thread paul rivers
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 looking for