Hidden columns in PostgreSQL tables

12 Sep 2015

See http://www.postgresql.org/docs/9.4/static/ddl-system-columns.html for more details, but instead of selecting * from your table, do this to get all of the hidden columns:

select tableoid, cmin, cmax, xmin, xmax, ctid, * from mytable;