Hello Atul, You can use set a filter to limit the tables returned, i.e:
\dt college.* HTH, Thomas Le mer. 24 févr. 2021 à 08:54, Atul Kumar <akumar14...@gmail.com> a écrit : > Hi, > > I have postgres 9.6 cluster running on centos 7 machine. > > when I set search_path to any user made schema with below command > > [enterprisedb@stg-edb02 ~ 01:51:39]$ psql edb > edb=# \c test > > set search_path to college; > > and after listing the tables with command \dt, we should get list of > tables of schema college only. > > but here I am getting list of tables of schema college and list of > tables of schema sys along with it. > > > Why is it happening, please suggest. > > > test=# \dt > List of relations > Schema | Name | Type | Owner > --------+---------------------------------+-------+-------------- > college | ta_rule_error | table | college > college | team_import | table | college > college | test_24022021 | table | enterprisedb > sys | callback_queue_table | table | enterprisedb > sys | dual | table | enterprisedb > sys | edb$session_wait_history | table | enterprisedb > sys | edb$session_waits | table | enterprisedb > sys | edb$snap | table | enterprisedb > sys | edb$stat_all_indexes | table | enterprisedb > sys | edb$stat_all_tables | table | enterprisedb > sys | edb$stat_database | table | enterprisedb > sys | edb$statio_all_indexes | table | enterprisedb > sys | edb$statio_all_tables | table | enterprisedb > sys | edb$system_waits | table | enterprisedb > sys | plsql_profiler_rawdata | table | enterprisedb > sys | plsql_profiler_runs | table | enterprisedb > sys | plsql_profiler_units | table | enterprisedb > sys | product_component_version | table | enterprisedb > sys | scheduler_0100_component_name | table | college > sys | scheduler_0200_program | table | college > sys | scheduler_0250_program_argument | table | college > sys | scheduler_0300_schedule | table | college > sys | scheduler_0400_job | table | college > sys | scheduler_0450_job_argument | table | college > > >
