Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sQofO-00Bmop-5F for pgsql-sql@arkaria.postgresql.org; Mon, 08 Jul 2024 13:44:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sQofM-0069c0-DR for pgsql-sql@arkaria.postgresql.org; Mon, 08 Jul 2024 13:44:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sQofM-0069bs-4m for pgsql-sql@lists.postgresql.org; Mon, 08 Jul 2024 13:44:28 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sQofJ-0012BG-3q for pgsql-sql@lists.postgresql.org; Mon, 08 Jul 2024 13:44:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1720446262; x=1721051062; i=shammat@gmx.net; bh=OQuT0QAJBfYoYmYTaaFaYbk/HQ6Fa4gnOCs0wlNLQTE=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To:Cc: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=trvH85slZoWOCBOgkKIVpZ93uX2SnetJnJdOPf6AtKv68eapthw5BQm7yNGrBJwF v4BHzCE/IBjuhcl0G+AkZXvLXdbQXJDcROhEFs1Nq9f/JFZWKwGBLlqXvtXSHcHEh ToqpF677B2riH/ZC0fTibo1DzymDiOqYJWUEZiin0ZZYLMNaHtmU/FxAjKHPj9Wf8 6Ac0U9gdDzaVLgU4s+tWbpF0T+XlFkq6UAr7Wy7vBTXBqQtdoTlz2NbOGPind3Wj7 M26LHP6K+0Dd29KgSCcgTvZZINEPJ0ZlUX/uSPVyIZanUvKAEShqsNaG7kQl5x96v 74slyPyb8AM0wX3vyA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.1.35.121] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1Mwwdf-1sAOdi413z-00vJ2L; Mon, 08 Jul 2024 15:44:22 +0200 Message-ID: Date: Mon, 8 Jul 2024 15:44:21 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Trick to create alias/mirror table To: intmail01 Cc: pgsql-sql@lists.postgresql.org References: Content-Language: de-DE, en-US From: shammat@gmx.net In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:RYO9qvecSU0xXxPTKJ6TzRRNDdc4BkhSG2oLLrBYMmRKpo9cxA3 ZmmCJsvI7uQQn9K2tU0JJdoZEiau450sODoMp3I0h0LFkx1wHmag4rbhkJQwXTa4KGUpctz NlJKKJoXIWjUlY1WcQXcaSQB25qh8pSnUpN7cqbSy+um8mhplxcyd5fZ1JF6NfaR09hgbIV xrPlgJNn5R+rUBj3Z5t1w== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:ef8p2WBtMmw=;S4FH104yZSCiyxUbpf4sjH0z6kx XD0RpCQ7GPtnfo7+pPPiU1MEu+fbGv3jio27re69BKDXMw0nAwEFXR90N6n7lrZ+SeE/L13Hi xA00YqIXd88scSaP2qin3SHhwk8XJOQ04WXeIIJYmBCY8rixUNAJltxcMs1LLA0XV5ipzjPnz y4CqDIO+VDc3gaa2cNH9z8wVhvFVShiH4SglU3ip0CTcQP0fpvBxKe1vcLX70ffORB24T+5zR QQ0vp7QX2DoECBdnkCS91q4ynVsFF84jD2e7Ia6ciyKjCdgm6RIVMxSgefLjDA2icVpCnO8ev Z8l03zTXXC9Wm344jWTwBlZTOAiqRgPi3c5sv4GovpVssvsSfIlG1W1rOlk8aYTD5iBVABkw3 hnD+NCrNo0X3hoka4zhTMsjxIZymel6D/eFq3G9Sq2Z3fPV+ilq/auDwKptdZbbc/mdp8QZVq 01M578UoSheeJah/QhJm3lGxu6z9WemS5tqP+krtlJ7mT17GqZ0xLfRASaSDLlBpyZuyqK/Sz r5HZ16ilwwidGlZep6+HJiwefSBBZ7acFbbpydaQCYlNLxLhvp7UfkGFytplCzojd1QLdm/gr qmDdfTCO9UhlH8mFrULs3DtYm0LIaKosMaA5nXbaYrpGJ6smzKAyY4C9tb2un0X4gWAYjeTQ3 EZRQacXrkZeIcArCHxuLBovVqFArHqq50TStdhh/tU6oHNeTdquDrw7TZMnANC4tA3AkZ+jEb NEj/SsJHSZtHUhkqw09EG3BwXF/mw5vD0xrPF4OZ2hEpIboOOeb7BbH2GGqwDNcFl8BeCOZoy dlbBK0SaCgmQFAeJzyEO8mKhjiLT2EjIQNXg5ckL4E8fo= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk intmail01 schrieb am 08.07.2024 um 15:04: > No. Simple view can not be updated with a GUI like PgAdmin or > LibreOffice Base. Only query code can modify it and every people can > not code sql. You might want to look for "no code" or "low code" solutions to provide an= end-user friendly GUI to edit the data. Tools in that direction that I have came across, but have never tried are = SQLPage, NocoDB or Budibase. Using a tool like that might even remove the need to "shield" the actual t= ables through views.