0 like 0 dislike
117 views
asked in PostgreSQL Database Forum by (5.3k points)  
Hi..can anyone help me to get Query to check which schema has default tablespace

Please log in or register to answer this question.

1 Answer

0 like 0 dislike
answered by (5.3k points)  

This query will check to which schema has default tablespace

select * from pg_tables where schemaname='tab_test';

Checking to which table has default tablespace

https://discuss.tutorialdba.com/799/how-find-tablespace-for-table

Related questions

0 like 0 dislike
0 answers
Welcome to PostgreSQL Database Discussion Forum where you can ask questions and receive answers from other members of the community. Can discuss here Oracle, Postgresql, mariadb , mySQL , AWS , Linux , MSSQL , MongoDB , Greenplum databases related queries ...etc.
...