Re: PGAdmin Version 2.1
| От | Dave Page |
|---|---|
| Тема | Re: PGAdmin Version 2.1 |
| Дата | |
| Msg-id | CA+OCxow=D4YqyQvC93o=W8EtG8df2c2c3h-x9_Jbua3dJOi=Tg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PGAdmin Version 2.1 (ldrlj1 <russelljanusz@masterpeaceltd.com>) |
| Ответы |
Re: PGAdmin Version 2.1
|
| Список | pgadmin-support |
On Tue, Jan 30, 2018 at 10:46 AM, ldrlj1 <russelljanusz@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
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
В списке pgadmin-support по дате отправления: