real-life.txt

$ psql --version
psql (PostgreSQL) 9.6.2

$ psql -h localhost
psql (9.6.2)

francois@localhost francois # select version();
                                                    version
----------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.6.2 on x86_64-apple-darwin15.6.0, compiled by Apple LLVM version 8.0.0 (clang-800.0.42.1), 64-bit

francois@localhost francois # set search_path to public;
francois@localhost francois # \dt
            List of relations
 Schema |    Name     | Type  |  Owner
--------+-------------+-------+----------
 public | event_types | table | francois
 public | events      | table | francois
 public | families    | table | francois

francois@localhost francois # set search_path to mybank;
francois@localhost francois # \dt
          List of relations
 Schema |   Name   | Type  |  Owner
--------+----------+-------+----------
 mybank | families | table | francois

francois@localhost francois # set search_path to mybank, public;
francois@localhost francois # \dt
            List of relations
 Schema |    Name     | Type  |  Owner
--------+-------------+-------+----------
 mybank | families    | table | francois
 public | event_types | table | francois
 public | events      | table | francois

repro.sql

create schema mybank;
create table public.a();
create table mybank.a();
set search_path to public;
\dt
set search_path to mybank;
\dt
set search_path to mybank, public;
\dt
set search_path to public, mybank;
\dt

repro.txt

$ psql --no-psqlrc --quiet repro -f b.sql
        List of relations
 Schema | Name | Type  |  Owner
--------+------+-------+----------
 public | a    | table | francois
(1 row)

        List of relations
 Schema | Name | Type  |  Owner
--------+------+-------+----------
 mybank | a    | table | francois
(1 row)

        List of relations
 Schema | Name | Type  |  Owner
--------+------+-------+----------
 mybank | a    | table | francois
(1 row)

        List of relations
 Schema | Name | Type  |  Owner
--------+------+-------+----------
 public | a    | table | francois
(1 row)