Postgres Pro
Downloads
Home   >   mailing lists

Can I read the data without commit - Mailing list pgsql-sql

From John Fabiani
Subject Can I read the data without commit
Date
Msg-id 2388789.tLQtTxa0cR@linux-12
Whole thread Raw
Responses Re: Can I read the data without commit
List pgsql-sql
Tree view 
Hi,
I know this is a newbie question but I have never had the need to do the 
following.

I start a transaction.
Begin

Then I insert a lot of data - let's say two hundred rows.

Now I need to read the same data (so the user can review).

If the user thinks all is right then 
commit.

Can I read the data I just inserted without committing?

Johnf

pgsql-sql by date:

Previous
From: Bear
Date:
Subject: Problem with inserting data produced by the function (when the function is performed).
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: Can I read the data without commit