• Create a table
• PostgreSQL view allows edit operation
• Transaction isolation does not resemble to the one used by Oracle database
  • Please review this article
  • http://www.postgresql.org/docs/9.1/static/transaction-iso.html
• Use Vacuum command

CREATE TABLE TT1
(
eid numeric(2,0) NOT NULL,
fname character varying(20),
lname character varying(30),
address character varying(100),
CONSTRAINT pk_tt1 PRIMARY KEY (eid)
)
WITH (
OIDS=FALSE
);
ALTER TABLE TT1
OWNER TO postgres;

Table created

Note the table created

I did psql.pane and updated this table, then ran vacuum command

The above screen shot suggested that "TT1" table did not have any row yet.

PostgreSQL db uses MVCC, and differs from Oracle transaction isolation

Now let us view all data, PostgreSQL view data menu displays the table with write/edit option

Now let us go back to psql