table size and storage location

Поиск
Список
Период
Сортировка
Искать

table size and storage location

От:
chuckee <mi6@orcon.net.nz>
Дата:

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

Also, how do I find out where the actual files for the database are stored
on my system?
Where is the default storage location?

Thanks!
Charlie
-- 
View this message in context: http://www.nabble.com/table-size-and-storage-location-tp16230697p16230697.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

FAQ