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 1sQo9n-00Bjz3-2n for pgsql-sql@arkaria.postgresql.org; Mon, 08 Jul 2024 13:11:51 +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 1sQo9l-005sX9-BZ for pgsql-sql@arkaria.postgresql.org; Mon, 08 Jul 2024 13:11:49 +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 1sQo9l-005sX0-1l for pgsql-sql@lists.postgresql.org; Mon, 08 Jul 2024 13:11:49 +0000 Received: from mail-oi1-x230.google.com ([2607:f8b0:4864:20::230]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sQo9i-0011uC-H5 for pgsql-sql@lists.postgresql.org; Mon, 08 Jul 2024 13:11:47 +0000 Received: by mail-oi1-x230.google.com with SMTP id 5614622812f47-3d921528dc4so1714767b6e.0 for ; Mon, 08 Jul 2024 06:11:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720444306; x=1721049106; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=p9ZPcKQQtu3C87pG5WCI7zd2lbbd1gkNDadqTvv/sx4=; b=KEI3QenvhRQYJNrOVtvLPlQ7c/EJxu01AHAu9RSUSpQFgAZGh4bgyMql8D2wfNDXzM CvEtRyza5+DEmnS0YiWqseexTjLPJLGKoLkNBKBmTlTRH2cfjxajjmpkJ+Sq3AH8uf1w 7MM1lpN7nI9cLn+aI6ZtC9iq/GIwvRrJ3XbBqt44oPlCLQ88vXXIopNfA2givGUizM7d 7rzzDKelmbBQaJu4yEbanNnDg5x0tdSP2naTm/exgWZKLDGNl9kDXh5CwRq72KYhpP6B azu5/lkdKDFvysD3/6TP7VIXPJcWZKct3+jSNex4R2AJcQAiZO8LxQl3qv8235J8zqUs DjNA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720444306; x=1721049106; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=p9ZPcKQQtu3C87pG5WCI7zd2lbbd1gkNDadqTvv/sx4=; b=RRit/quaJofa9sh72SzhbuCTgwRddIBA6fJWqQW2AzcA5pipouUYkhFZeTluDD/Oar Eu0s7+dm5b+7lDOhYuUR6b4vTzoXltI0HUW/KaCraWMawrB0eCsmXYmb03y1m5lgpXPH Nu+XeH1UZJNqwFL40LTOwt/9rEC93blZknxozRWLz5cE18mrBydWjwcVDIdnfMiBY+JR WYhaTwhlMA7SXOcUDGRHsLv8VHXoNDIPaHQdf3w2hGcFn409UOs6RD+E8uWxkJuibd/f 3vbVvJxXEZ+H4BXr/lOeU7yqjxwL6k13rm2p22V18yZHMKXsoTWlDprOpcCtMBuNdFIB BqkA== X-Forwarded-Encrypted: i=1; AJvYcCX32MOzVWb62Z7BAn9mYL+bg7ORKR0uZAkQA/XRZQmnjRN9RNUbPUQWHB6azBOhqPHhqQanV/qxrImho2YL2iXvDJ2/AzGBL3DPiNq5ruE= X-Gm-Message-State: AOJu0Yx2WyMVZRKzKf2wEFHIQ6rZDuwErCgN/KXYLXsUfwoN4jTTc+RH yPMVc7cXzBTBpNymy68lbFtF4xvflIlu/JKijHJ89kJP/GqBD6WZSlKzaBQVC1VlHH0G7LvGrgx aMo1DLwytV8trHsjkdndRnFq4wqg= X-Google-Smtp-Source: AGHT+IEa22AWVy+sIEdO2IittQESR4W4QnvvVS3IHWjAfRSEojnptYMABtxaIxLYV1xKsB9S6CiTpJTOR7hKry0Sgh0= X-Received: by 2002:a05:6808:14c2:b0:3d9:20ff:427a with SMTP id 5614622812f47-3d920ff47cfmr12304727b6e.12.1720444305416; Mon, 08 Jul 2024 06:11:45 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6214:21ec:b0:6b5:ed1e:7a5e with HTTP; Mon, 8 Jul 2024 06:11:44 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Mon, 8 Jul 2024 06:11:44 -0700 Message-ID: Subject: Re: Trick to create alias/mirror table To: intmail01 Cc: "shammat@gmx.net" , "pgsql-sql@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000ae2b2e061cbc2747" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ae2b2e061cbc2747 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, July 8, 2024, intmail01 wrote: > 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. > Fair. But updatable views are the solution PostgreSQL provides to your use case. That client applications aren=E2=80=99t fully exposing it to the use= r is unfortunate. There isn=E2=80=99t another way of doing this aside from havi= ng a bunch of synchronized tables done probably with manual triggers. David J. --000000000000ae2b2e061cbc2747 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, July 8, 2024, intmail01 <intmail01@gmail.com> wrote:
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 c= ode sql.

Fair.=C2=A0 But updatable vi= ews are the solution PostgreSQL provides to your use case.=C2=A0 That clien= t applications aren=E2=80=99t fully exposing it to the user is unfortunate.= =C2=A0 There isn=E2=80=99t another way of doing this aside from having a bu= nch of synchronized tables done probably with manual triggers.
David J.
--000000000000ae2b2e061cbc2747--