Re: Trick to create alias/mirror table
| От | intmail01 |
|---|---|
| Тема | Re: Trick to create alias/mirror table |
| Дата | |
| Msg-id | CAKJANSCZa_q7SpAwmN1K1vbFcQd5+u0L8JZ5+fA16ucG7iv6kw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Trick to create alias/mirror table (shammat@gmx.net) |
| Ответы |
Re: Trick to create alias/mirror table
Re: Trick to create alias/mirror table Re: Trick to create alias/mirror table |
| Список | pgsql-sql |
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 PM <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.
В списке pgsql-sql по дате отправления: