From: | Atul Kumar <akumar14871(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | getting tables list of other schema too |
Date: | 2021-02-24 07:54:34 |
Message-ID: | CA+ONtZ5mwNSStj-XvUz22N8hMnVBX7FDfZVEqVzFP8pejpJpqA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Boussekey | 2021-02-24 10:08:31 | Re: getting tables list of other schema too |
Previous Message | Santosh Udupi | 2021-02-24 02:18:06 | Re: pg_restore - generated column - not populating |