Postgres Pro
Downloads
Home   >   mailing lists

table size and storage location - Mailing list pgsql-general

From chuckee
Subject table size and storage location
Date
Msg-id 16230697.post@talk.nabble.com
Whole thread Raw
Responses Re: table size and storage location  (paul rivers <rivers.paul@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Keaton Adams
Date:
Subject: How to concatenate a boolean to a text string for an EXECUTE stmt in a stored proc
Next
From: chuckee
Date:
Subject: table size and storage location