Search Postgresql Archives

Re: getting tables list of other schema too

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux