Search Postgresql Archives

Re: getting tables list of other schema too

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

 



I am sorry but I am not clear from your response, as I have created
another instance with same version 9.6 but there no system schema or
its tables are visible.

Please help.






On 2/24/21, Francisco Olarte <folarte@xxxxxxxxxxxxxx> wrote:
> On Wed, Feb 24, 2021 at 12:12 PM Francisco Olarte
> <folarte@xxxxxxxxxxxxxx> wrote:
>> AFAIK dt list "tables", not "tables in the schemas in search path".
>> It states " By default, only user-created objects are shown; supply a
>> pattern or the S modifier to include system objects.", but these sys
>> schema does not seem to be a system one.
>
> Zap it, after (incorrectly after posting) searching for "schema" in
> the docs I found, in a paragraph far, far, away, \d* uses search path.
>
> Francisco Olarte.
>





[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