Re: Enum on-disk format

Scott Bailey <artacus(at)comcast(dot)net> writes:
> I'm trying to better understand the internals of Postgres, and I'm
> looking at the enum type. The docs say that an enum value is stored on
> disk as 4 bytes. But enum_send() returns a bytea representing the actual
> text of the value and not the index of that value. So what step am I
> missing here?

The wire format isn't necessarily the on-disk format. In this case
we concluded that the internal OID value wouldn't be of any use to
clients.

> Also, is there a way to see the raw data for the tuple on a page?

Try contrib/pageinspect, and read
http://developer.postgresql.org/pgdocs/postgres/storage-page-layout.html

regards, tom lane