| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | ourdiaspora <ourdiaspora(at)protonmail(dot)com>, Francisco Olarte <folarte(at)peoplecall(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Visibility of data from table inherits function |
| Date: | 2022-01-02 19:55:36 |
| Message-ID: | 830db592-c67e-65a1-db73-a7fe7f9f49d6@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 1/2/22 11:41, ourdiaspora wrote:
> On Sunday, January 2nd, 2022 at 3:54 PM, Francisco Olarte <folarte(at)peoplecall(dot)com> wrote:
>>
>> Inherits does not copy things. LIKE on creation does, but AFAIK it can
>>
>> copy nearly everything except data.
>>
>
> Thanks, had read that part of the documentation.
>
> So far it seems that functions 'joins' may be used to view data, whilst the functions 'views' is unable to be used with data entry.
They are not functions. A join is a clause in a query. A view is an
object that can be created and then used like a table.
Views can be used for data entry, see:
https://www.postgresql.org/docs/current/sql-createview.html
Search for section:
Updatable Views
>
> Please, any suggestions of an alternative function to use?
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2022-01-02 21:37:04 | Re: Visibility of data from table inherits function |
| Previous Message | ourdiaspora | 2022-01-02 19:41:56 | Re: Visibility of data from table inherits function |