On Tue, Jan 30, 2018 at 10:46 AM, ldrlj1 <russelljan...@masterpeaceltd.com> wrote:
> Interesting... and thank you! > While I did expect to see tableoid, cmax, xmax, cmin, xmin and ctid in my > tables... I never expected turning on "Show system objects" would show > sequences and tables as Postgres Types. > > So I am knowledgeable, can you explain why that happens? In Postgres, the row schema of objects in pg_class (tables, sequences, views etc) is also a "row-type". Effectively, a composite type that can represent a row in a class: https://www.postgresql.org/docs/10/static/plpgsql-declarations.html#PLPGSQL-DECLARATION-ROWTYPES -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company