let me correct on this query, it shows only those tables which wont belong to default_tablespace...
select relname,reltablespace from pg_class where reltablespace in(select oid from pg_tablespace where spcname not in ('pg_default','pg_global')); --- Best Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Tue, Jun 21, 2011 at 12:55 AM, Raghavendra < raghavendra....@enterprisedb.com> wrote: > hmmm....Strange.. > > What is the output of > > select oid,* from pg_tablespace; > > and > > select relname,reltablespace from pg_class where relname=' > application_category'; > > > --- > Best Regards, > Raghavendra > EnterpriseDB Corporation > Blog: http://raghavt.blogspot.com/ > > > > On Tue, Jun 21, 2011 at 12:48 AM, hyelluas <helen_yell...@mcafee.com>wrote: > >> well, >> >> here is the query : >> >> profiler1=# select relname,reltablespace from pg_class where reltablespace >> in(select oid from pg_tablespace where spcname not in >> ('pg_default','pg_global')); >> relname | reltablespace >> ---------+--------------- >> >> >> why it shows no records? >> >> profiler1=# select * from pg_catalog.pg_tables where >> tablename='application_category'; >> schemaname | tablename | tableowner | tablespace | hasindexes >> | >> hasrules | hastrigge >> rs >> >> ------------+----------------------+------------+------------+------------+----------+---------- >> --- >> public | application_category | postgres | | t >> | >> f | f >> (1 row) >> >> >> and that query show empty for the tablespace... >> >> thank you >> Helen >> >> -- >> View this message in context: >> http://postgresql.1045698.n5.nabble.com/how-to-find-a-tablespace-for-the-table-tp4500200p4507624.html >> Sent from the PostgreSQL - general mailing list archive at Nabble.com. >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >