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 looking for pg_relation_size('capture') or
pg_total_relation_size('capture'). A tablespace is a named location for
creating objects.
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!
