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
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
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
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!
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
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