Re: How to reference a composite type in schemas not "public"?

[Adrian Klaver]

On 06/13/2018 10:34 PM, a wrote:

Sorry I was in the wrong db last time

TESTDB=# \dn
 ?0?2 ?0?2 ????????????
 ?0?2 ?????0?2 ?0?2|?0?2 ??????
---------+----------
 ?0?2MjorTbl | postgres
 ?0?2Rate?0?2 ?0?2 | postgres
 ?0?2public?0?2 | postgres

In addition try:

\dT "MjorTbl".mort


--
Adrian Klaver
adrian.kla...@aklaver.com