Re: how to find a tablespace for the table?

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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>