PGConf NYC 2021 - Advanced Data Types in PostgreSQL by Andreas Scherbaum

Advanced Data Types in PostgreSQL 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.