MIME-Version: 1.0
References: 
 <CAKJANSDruTfkYCCKuWr3camHGLuO67s-=DYX-Kjv4fQMkhn09g@mail.gmail.com>
In-Reply-To: 
 <CAKJANSDruTfkYCCKuWr3camHGLuO67s-=DYX-Kjv4fQMkhn09g@mail.gmail.com>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Mon, 8 Jul 2024 16:55:37 +0500
Message-ID: 
 <CAAPsdhfjafr4zOWN7nXFmd5uaga_JCw7QECiRCnpN-giRRENRg@mail.gmail.com>
Subject: Re: Trick to create alias/mirror table
To: intmail01 <intmail01@gmail.com>
Cc: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001704b0061cbb18bb"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAPsdhfjafr4zOWN7nXFmd5uaga_JCw7QECiRCnpN-giRRENRg%40mail.gmail.com>
Precedence: bulk

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

Hi

You can use following options

1. Postgres FDW
2. Materialized Views


Regards
Kashif Zeeshan

On Mon, Jul 8, 2024 at 4:25=E2=80=AFPM intmail01 <intmail01@gmail.com> wrot=
e:

>
>
> Hi,
> Looking for a trick to make something like an alias or a mirror table. Th=
e
> 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.
>
> Thanks
>

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

<div dir=3D"ltr">Hi<div><br></div><div>You can use following options</div><=
div><br></div><div>1. Postgres FDW</div><div>2. Materialized Views</div><di=
v><br></div><div><br></div><div>Regards</div><div>Kashif Zeeshan</div></div=
><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mo=
n, Jul 8, 2024 at 4:25=E2=80=AFPM intmail01 &lt;<a href=3D"mailto:intmail01=
@gmail.com">intmail01@gmail.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><table cellpadding=3D"0">=
<tbody><tr><td colspan=3D"2"><br></td><td colspan=3D"2"><br></td></tr></tbo=
dy></table><div>Hi,</div><div>Looking for a trick to make something like an=
 alias or a mirror table. The alias can be updated. View is not suitable be=
cause it is read only data. The alias is always linked to the original tabl=
e. When a modification occurred in the original table this will be visible =
in all link tables.</div><div><br></div><div>Thanks<br></div></div>
</blockquote></div>

--0000000000001704b0061cbb18bb--