Postgres Pro
Downloads
Home   >   mailing lists

update one table from multiple tables postgres - Mailing list pgsql-general

From akp geek
Subject update one table from multiple tables postgres
Date
Msg-id AANLkTikZt4Ew+3b+n9cd_Tu8m-kNinDkCWSxepBoC6zf@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
Hi All -

              I need to update one table with the data from multiple tables. 

               1. I have created a trigger on a table table 
               2. Create a view with all the logic
               3. created a trigger funtion.
with in the function, I have tried to populate the table, but I am not able to get hold of the data from the other tables where there is no trigger on those tables.

Can you please help giving me suggestion on how to implement it

Kind Regards

pgsql-general by date:

Previous
From: Sébastien Lardière
Date:
Subject: Re: Alter Table + Default Value + Serializable
Next
From: Andreas Brandl
Date:
Subject: PITR on different machine/architecture?