What is the equivalent of timestamp/rowversion (SQL Server) with PostgreSQL

See the system columns section in PostgreSQL documentation. In particular, xmin might be what you're looking for.

But be careful using any system columns. They are by definition implementation specific and the details of some of them might change with future versions.