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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
