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  (Melvin Davidson <melvin6925@yahoo.com>)
Список 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

В списке pgadmin-support по дате отправления:

Предыдущее
От: ldrlj1
Дата:
Сообщение: Re: PGAdmin Version 2.1
Следующее
От: Murtuza Zabuawala
Дата:
Сообщение: Re: PGAdmin Version 2.1