Skip site navigation (1) Skip section navigation (2)

Re: How to check tablespace

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 (view raw or flat)
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 

pgsql-novice by date

Next:From: Keith WorthingtonDate: 2005-05-19 15:01:45
Subject: Re: database conversion to postgres
Previous:From: Tom LaneDate: 2005-05-19 05:29:36
Subject: Re: How to check tablespace

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group