getting tables list of other schema too

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

Responses

Browse pgsql-general by date

  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