From: | Low Kian Seong <postgresql_low(at)yahoo(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How to check tablespace |
Date: | 2005-05-19 05:40:41 |
Message-ID: | 20050519054041.33271.qmail@web31603.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
when i do a 'SELECT * FROM pg_tablespace', i see this
:
spcname | spcowner | spclocation
|spcacl
------------+----------+-------------------------+--------
pg_default | 1 | |
pg_global | 1 | |
dbspace | 1 | /usr/local/pgsql/pgsql2 |
but how do i ascertain which spcname it's kept in ?
thanks.
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Low Kian Seong <postgresql_low(at)yahoo(dot)com> writes:
> > ... how do i check the location of the tablespace
> > where it is kept in the filesystem ?
>
> Look into the pg_tablespace catalog.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Worthington | 2005-05-19 15:01:45 | Re: database conversion to postgres |
Previous Message | Tom Lane | 2005-05-19 05:29:36 | Re: How to check tablespace |