From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | ldrlj1 <russelljanusz(at)masterpeaceltd(dot)com> |
Cc: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: PGAdmin Version 2.1 |
Date: | 2018-01-30 11:08:07 |
Message-ID: | CA+OCxow=D4YqyQvC93o=W8EtG8df2c2c3h-x9_Jbua3dJOi=Tg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Tue, Jan 30, 2018 at 10:46 AM, ldrlj1 <russelljanusz(at)masterpeaceltd(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Murtuza Zabuawala | 2018-01-30 11:12:47 | Re: PGAdmin Version 2.1 |
Previous Message | ldrlj1 | 2018-01-30 10:46:39 | Re: PGAdmin Version 2.1 |