This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
postgresql [2015/06/26 14:21] mihael |
postgresql [2017/06/27 07:20] mihael |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== PostgreSQL ====== | ====== PostgreSQL ====== | ||
+ | |||
+ | ===== Row Id ===== | ||
+ | Each table has a column CTID which holds the row id of a row. | ||
+ | |||
+ | SELECT ctid FROM mytable; | ||
+ | |||
===== Current Transactions ===== | ===== Current Transactions ===== |