MIME-Version: 1.0
References: 
 <CAKJANSDruTfkYCCKuWr3camHGLuO67s-=DYX-Kjv4fQMkhn09g@mail.gmail.com>
 <bc341eab-3fa6-48f5-955d-046e30093389@gmx.net>
In-Reply-To: <bc341eab-3fa6-48f5-955d-046e30093389@gmx.net>
From: intmail01 <intmail01@gmail.com>
Date: Mon, 8 Jul 2024 16:04:55 +0300
Message-ID: 
 <CAKJANSCZa_q7SpAwmN1K1vbFcQd5+u0L8JZ5+fA16ucG7iv6kw@mail.gmail.com>
Subject: Re: Trick to create alias/mirror table
To: shammat@gmx.net
Cc: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a5f57f061cbc0840"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKJANSCZa_q7SpAwmN1K1vbFcQd5%2Bu0L8JZ5%2BfA16ucG7iv6kw%40mail.gmail.com>
Precedence: bulk

--000000000000a5f57f061cbc0840
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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.

On Mon, Jul 8, 2024 at 3:09=E2=80=AFPM <shammat@gmx.net> wrote:

> intmail01 schrieb am 08.07.2024 um 13:27:
> > Hi, Looking for a trick to make something like an alias or a mirror
> > table. The alias can be updated. View is not suitable because it is
> > read only data. The alias is always linked to the original table.
> > When a modification occurred in the original table this will be
> > visible in all link tables.
>
> This sounds very much as if a view would solve that requirement.
>
> Views can be updated in Postgres. Either automatically if it's a "simple
> view"
> or by providing a function that handles the DML.
>
>
>
>

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

<div dir=3D"ltr">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 no=
t code sql.<br></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=
=3D"gmail_attr">On Mon, Jul 8, 2024 at 3:09=E2=80=AFPM &lt;<a href=3D"mailt=
o:shammat@gmx.net">shammat@gmx.net</a>&gt; wrote:<br></div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex">intmail01 schrieb am 08.07.2024 um 13:27:=
<br>
&gt; Hi, Looking for a trick to make something like an alias or a mirror<br=
>
&gt; table. The alias can be updated. View is not suitable because it is<br=
>
&gt; read only data. The alias is always linked to the original table.<br>
&gt; When a modification occurred in the original table this will be<br>
&gt; visible in all link tables.<br>
<br>
This sounds very much as if a view would solve that requirement.<br>
<br>
Views can be updated in Postgres. Either automatically if it&#39;s a &quot;=
simple view&quot;<br>
or by providing a function that handles the DML.<br>
<br>
<br>
<br>
</blockquote></div>

--000000000000a5f57f061cbc0840--