table size and storage location

Поиск
Список
Период
Сортировка
От chuckee
Тема table size and storage location
Дата
Msg-id 16230697.post@talk.nabble.com
обсуждение исходный текст
Ответы Re: table size and storage location
Список pgsql-general
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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Keaton Adams
Дата:
Сообщение: How to concatenate a boolean to a text string for an EXECUTE stmt in a stored proc
Следующее
От: chuckee
Дата:
Сообщение: table size and storage location