Re: Visibility of data from table inherits function - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Visibility of data from table inherits function
Date
Msg-id 830db592-c67e-65a1-db73-a7fe7f9f49d6@aklaver.com
Whole thread Raw
In response to Re: Visibility of data from table inherits function  (ourdiaspora <ourdiaspora@protonmail.com>)
List pgsql-general
On 1/2/22 11:41, ourdiaspora wrote:
> On Sunday, January 2nd, 2022 at 3:54 PM, Francisco Olarte <folarte@peoplecall.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
withdata 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: ourdiaspora
Date:
Subject: Re: Visibility of data from table inherits function
Next
From: Achilleas Mantzios
Date:
Subject: Re: Visibility of data from table inherits function