Actually to say, everything looks ok to me, until unless you say the table * '**application_category'* on other tablespace ... :)
profiler1=# select relname,reltablespace from pg_class where >> relname='application_category'; >> relname | reltablespace >> ----------------------+--------------- >> application_category | 0 >> (1 row) >> >> Above result, indicates that its in default tablespace. http://www.postgresql.org/docs/9.0/static/catalog-pg-class.html Regards Raghav > >> -- >> View this message in context: >> http://postgresql.1045698.n5.nabble.com/how-to-find-a-tablespace-for-the-table-tp4500200p4508040.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 >> > >