There are a few columns that are defined by Postgres for its use (i.e. tableoid, cmax, xmax, cmin, xmin, ctid) that I would like to view the values of.
I tried running the following query in the query tool:
SELECT * FROM public."MyTable"
but it only returns my user-generated columns and nothing else.
I can see these columns exist when I expand the Table>Columns list but I can't find an option to enable viewing their values.
CodePudding user response:
Try adding the columns to your select statement like
select tableoid,cmax, xmax, cmin, xmin, ctid, * from public."MyTable";