Date: Fri, 20 Jan 2017 10:11:26 -0500
From: Stephen Frost <sfrost@snowman.net>
To: John Scalia <jayknowsunix@gmail.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: behavior of \dt and schemas
Message-ID: <20170120151126.GQ18360@tamriel.snowman.net>
References: 
 <CABzCKRAoMHjwr__4Y6tEmF8HAm2yZhEgPVqwg8=Y8_1-cfDjsg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="3R3nSPuqRo8A3eCW"
Content-Disposition: inline
In-Reply-To: 
 <CABzCKRAoMHjwr__4Y6tEmF8HAm2yZhEgPVqwg8=Y8_1-cfDjsg@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--3R3nSPuqRo8A3eCW
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

John,

* John Scalia (jayknowsunix@gmail.com) wrote:
> So far so good, and I get a similar output If I just set the search_path to
> B, only now it properly shows the schema as b. However, if I set the
> search_path to a, b; and enter \dt, I only see the tables from the first
> schema "a", like the above. and not the second schema. I would have
> expected:

That's intentional as an unqualified object reference would pick up the
object from the schema which shows up first in your search_path.

> So, to me this is somewhat non-intuitive behavior, but maybe I'm all wet
> here. Shouldn't \dt report all the tables it can see with the search_path
> set to some value? And btw, this is was the behavior on 9.4.10, so if it's
> changed in more recent versions, I haven't tested there yet.

It's not changed.

Thanks!

Stephen

--3R3nSPuqRo8A3eCW
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJYgiidAAoJEO1sijiDR2RV8tQP+wVddWqnsncKwmz5IVu615T/
2baMJ9lLdSd5xm0rVZAnzX0mv4zQEYnRbp92rbqztf3JLOCBlR0CDFnytAgyGSl/
l6a+H5FBp2sdtRMwPBi01IGeIiarw14Ody7rHsdXalh+MsAtv5Kz8lj9wJFFUlxx
C5SA3VuWE/TCwf6Vv6UdUC+IolBZQ/kGyrbOSipR2KK2gAM49Emwwc/bMJJhIFmH
AhRvEtRwmfJDveef7LQaX3TnjberYWvIkIOYfZ5Kw1VWyhSK84uWW5+65hshRCR7
kCZ1yJmvhpSh2gRRuEFj1r2tPDbjxicEjMN5wczoznDXBq5zdxpQOlmFWS7WL6P9
pYER0hN5+uQQw3qQbp3d8w/DxbkgNLViUpHjOSdw5pgsGx3Wk632AYbHxwf50HZi
H8LqrxA3faTEcmKJmS0el8bNyDDUn5j3Bq9Tpjku68ixJhcLIoq5l72xBaXz0dbO
2NvITRDiDm4W6ryflSp5aSAkzJf+MEGyf799DJ/rQCS9D/bpgNCzKVwF4BPTQ9jA
jSc3GraEGCUuD/wKOs5WGoVj2PL5x+GFLOtqLpKSboO26cAxmCh0E7bysRzIWwIB
tYh8Sh7/yennmtio1lbLQWjDVFlr5KmCe+Vwj8s96AogdGBhm+OGcrqcAduyk+Qy
ZgvpaaUYnic7rkr7TBos
=HC+F
-----END PGP SIGNATURE-----

--3R3nSPuqRo8A3eCW--