Re: helo

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: helo
Date: 2010-01-21 04:13:00
Message-ID: 4B57D44C.9080400@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

  • helo at 2010-01-21 04:01:26 from beulah prasanthi

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2010-01-21 06:04:22 Re: helo
Previous Message beulah prasanthi 2010-01-21 04:01:26 helo