> > 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)
Whats the output of this.. 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 2:16 AM, hyelluas <helen_yell...@mcafee.com> wrote: > here it is : > > > profiler1=# select oid,* from pg_tablespace; > oid | spcname | spcowner | spclocation | spcacl > -------+------------+----------+----------------------+-------- > 1663 | pg_default | 10 | | > 1664 | pg_global | 10 | | > 19955 | profiler1 | 10 | /data/psql/profiler1 | > (3 rows) > > > profiler1=# select relname,reltablespace from pg_class where > reltablespace=19955; > relname | reltablespace > ---------+--------------- > (0 rows) > > > thanks > Helen > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/how-to-find-a-tablespace-for-the-table-tp4500200p4508020.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 >
