PSQL supports the ReadCommitted and Serializable isolation levels. PSQL supports record-level locking. See Locking and Isolation Levels for details.