Search Postgresql Archives

Re: how to find a tablespace for the table?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux