Postgres Pro
Downloads
Home   >   mailing lists

Re: how to find a tablespace for the table? - Mailing list pgsql-general

From Raghavendra
Subject Re: how to find a tablespace for the table?
Date
Msg-id BANLkTinwtbUHvxGsKR--HzEO=NQCRgc7Fg@mail.gmail.com
Whole thread Raw
In response to Re: how to find a tablespace for the table?  (hyelluas <helen_yelluas@mcafee.com>)
Responses Re: how to find a tablespace for the table?  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general
Tree view
Can you give a try updating the catalogs with ANALYZE command and re-check ?

---
Best Regards,
Raghavendra
EnterpriseDB Corporation



On Tue, Jun 21, 2011 at 2:22 AM, hyelluas <helen_yelluas@mcafee.com> wrote:
profiler1=# select relname,reltablespace from pg_class where
relname='application_category';
      relname        | reltablespace
----------------------+---------------
 application_category |             0
(1 row)


--
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

pgsql-general by date:

Previous
From: Condor
Date:
Subject: Re: insert a SYSTIMESTAMP value in postgres
Next
From: Raghavendra
Date:
Subject: Re: how to find a tablespace for the table?