How do I find out what tablespace a table (or index) is in with PostgreSQL (9.3)?
2
-
2pg_tables, pg_indexesAbelisto– Abelisto2016-07-25 09:29:43 +00:00Commented Jul 25, 2016 at 9:29
-
\l+ \d+ works ..Glenn Plas– Glenn Plas2017-05-04 01:27:12 +00:00Commented May 4, 2017 at 1:27
Add a comment
|
1 Answer
For example, you have a table example_table (optionally in more than one schema):
SELECT tablespace
FROM pg_tables
WHERE tablename = 'example_table' [AND schemaname = 'your_schema'];
The same thing for the index example_index:
SELECT tablespace
FROM pg_indexes
WHERE indexname = 'example_index' [AND schemaname = 'your_schema'];
