Re: how to find a tablespace for the table?

thank you Greg,

here is what I get, I createed view as you suggested.
I'm not sure why tablespace column is empty

profiler1=# select * from pg_tables where schemaname ='public' limit 10;
schemaname | tablename | tableowner | tablespace | hasindexes
| hasrules | hastri
ers
------------+-------------------------+------------+------------+------------+----------+-------
----
public | ttt | postgres |
| f | f | f
public | summ_hrly_1514609 | postgres | | t
| f | f
public | summ_5min_1514610 | postgres | | t
| f | f
public | exp_cnt | postgres |
| f | f | f
public | auth_type | postgres | |
t | f | f
public | druid_mapping | postgres | |
t | f | f
public | application_category | postgres | | t
| f | f
public | application_risk | postgres |
| t | f | f
public | policy_history | postgres |
| t | f | f
public | datasource | postgres | |
t | f | f
(10 rows)

thank you.
Helen

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