Скачать или смотреть Advanced Data Types in PostgreSQL at PgDay San Francisco 2020

A talk by Andreas Scherbaum.

The “Tour de Data Types” talk provided an overview of the rich set of basic data types in PostgreSQL. But there are more data types available, which can and should be used in applications. PostgreSQL also allows you to combine simple types into more complex structures, or create your very own data type.

This talk starts with ENUM types, and how to create and use them. From there we will discover Arrays and Composite types, look into Range types and finally learn how you can create your own data type.

ANDREAS SCHERBAUM: Andreas Scherbaum is working with PostgreSQL since 1997. He is involved in several PostgreSQL related community projects, member of the Board of Directors of the European PostgreSQL User Group and also wrote a PostgreSQL book (in German). Since 2011 he is working for EMC/Greenplum/Pivotal and tackles very big databases.

Conference link: https://postgresql.us/events/pgdaysf2...