MIME-Version: 1.0
From: intmail01 <intmail01@gmail.com>
Date: Fri, 22 Mar 2024 10:11:23 +0300
Message-ID: 
 <CAKJANSDpz7TXn30vv1HVSjRv0N+xSnyiSnfyMdFaeXh1_yfFuw@mail.gmail.com>
Subject: How to choose table in SELECT clause without schema qualifier or 'set
 local'
To: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000003b850e06143a86cd"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKJANSDpz7TXn30vv1HVSjRv0N%2BxSnyiSnfyMdFaeXh1_yfFuw%40mail.gmail.com>
Precedence: bulk

--0000000000003b850e06143a86cd
Content-Type: text/plain; charset="UTF-8"

Hi,

My db have many schemas (company name) and there are SELECT code related to
tables that I distribute for each company users.

The structure inside are the same for all schemas.

It is a nightmare to change code each time to modify the schema qualifier
or SET LOCAL search_path when I add a new company.
Is there command, configurations or any trick to not modify code each time
I add company then code can works for any schema.

Thanks.

--0000000000003b850e06143a86cd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div><br></div><div>My db have many schemas =
(company name) and there are SELECT code related to tables that I distribut=
e for each company users.</div><div><br></div><div>The structure inside are=
 the same for all schemas.</div><div><br></div><div>It is a nightmare to ch=
ange code each time to modify the schema qualifier or SET LOCAL search_path=
 when I add a new company.</div><div>Is there command, configurations or an=
y trick to not modify code each time I add company then code can works for =
any schema.<br></div><div><br></div><div>Thanks.<br></div><div><br></div></=
div>

--0000000000003b850e06143a86cd--