Re: how to find a tablespace for the table?

here it is :


profiler1=# select oid,* from pg_tablespace;
  oid  |  spcname   | spcowner |     spclocation      | spcacl
-------+------------+----------+----------------------+--------
  1663 | pg_default |       10 |                      |
  1664 | pg_global  |       10 |                      |
 19955 | profiler1  |       10 | /data/psql/profiler1 |
(3 rows)


profiler1=# select relname,reltablespace from pg_class where
reltablespace=19955;
 relname | reltablespace
---------+---------------
(0 rows)


thanks
Helen

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-find-a-tablespace-for-the-table-tp4500200p4508020.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.