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..
On Tue, Jun 21, 2011 at 2:16 AM, hyelluas <helen_yelluas@xxxxxxxxxx> 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)
reltablespace=19955;
profiler1=# select relname,reltablespace from pg_class where
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
