Re: helo - Mailing list pgsql-general

From John R Pierce
Subject Re: helo
Date
Msg-id 4B57D44C.9080400@hogranch.com
Whole thread Raw
In response to helo  (beulah prasanthi <itsbeulah@gmail.com>)
List pgsql-general
beulah prasanthi wrote:
> I am using postgres 8.4
> using views i retrived some details from multiple tables
> can i insert the data into multiple tables using views.if not
> how can i insert the data into multiple tables in a single trip
> is there any option .Please help me

use a transaction bracketed by BEGIN; and COMMIT;  to execute a series
of inserts or updates as a single atomic operation.



pgsql-general by date:

Previous
From: beulah prasanthi
Date:
Subject: helo
Next
From: Adrian von Bidder
Date:
Subject: Re: more docs on extending postgres in C