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.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general