Re: getting tables list of other schema too

yes I know that, but my doubt is why \dt is showing tables of other
schemas even I am setting the search_path.

Regards,
Atul

On 2/24/21, Thomas Boussekey <thomas(dot)boussekey(at)gmail(dot)com> wrote:
> 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 <akumar14871(at)gmail(dot)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(at)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
>>
>>
>>
>