Search Postgresql Archives

Re: Visibility of data from table inherits function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 1/2/22 11:41, ourdiaspora wrote:
On Sunday, January 2nd, 2022 at 3:54 PM, Francisco Olarte <folarte@xxxxxxxxxxxxxx> 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.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux