Where in the DB is the Location of a postgres tablespace stored
<p>I am using postgres 9.2 on redhat 6 </p>

<p>this should be simple but I can't find it anywhere. I am looking for the database table and column which stores the Location for a postgres tablespace, I thought it would be in PG_TABLESPACE, but </p>

<pre><code>select * from pg_tablespace
</code></pre>

<p>shows...</p>

<pre><code>postgres=# select * from pg_tablespace;
     spcname     | spcowner | spcacl | spcoptions
-----------------+----------+--------+------------
 pg_default      |       10 |        |
 pg_global       |       10 |        |
 C_TBL_DB91SABIR |       10 |        |
(3 rows)
</code></pre>

<p>but no location, any ideas where the location is kept?</p>

<p>thanks</p>