table size and storage location

From: chuckee <mi6(at)orcon(dot)net(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: table size and storage location
Date: 2008-03-23 02:32:12
Message-ID: 16230697.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

2) 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Inoqulath 2008-03-23 12:36:36 Re: Installing on Windows without using msi Installer
Previous Message Alvaro Herrera 2008-03-23 02:31:58 Re: MySQL to Postgres question