Atul.
Due to your top posting style and not being a native english speaker
I'm unable to understand your question.
As all the quotes at the bottom seemed to belong to me, I'm assuming
you referred to some of my postings.
As the last one said I tried to point a thing after checking some
docs,
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 wrote:
> On Wed, Feb 24, 2021 at 12:12 PM Francisco Olarte
> wrote:
>> AFAIK dt list
On Wed, Feb 24, 2021 at 12:12 PM Francisco Olarte
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
Atul:
On Wed, Feb 24, 2021 at 11:24 AM Atul Kumar wrote:
> yes I know that, but my doubt is why \dt is showing tables of other
> schemas even I am setting the search_path.
AFAIK dt list "tables", not "tables in the schemas in search path".
It states " By default, only user-created objects are
On Wed, 2021-02-24 at 15:54 +0530, Atul Kumar wrote:
>
> > > 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;
>
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 wrote:
> Hello Atul,
>
> You can use set a filter to limit the tables returned, i.e:
>
> \dt college.*
>
> HTH,
> Thomas
>
>
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 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
>
>
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
