{"id":1586,"date":"2025-01-09T15:12:21","date_gmt":"2025-01-09T08:12:21","guid":{"rendered":"https:\/\/www.pgtutorial.com\/?page_id=1586"},"modified":"2025-01-09T16:31:55","modified_gmt":"2025-01-09T09:31:55","slug":"postgresql-composite-types","status":"publish","type":"page","link":"https:\/\/www.pgtutorial.com\/postgresql-tutorial\/postgresql-composite-types\/","title":{"rendered":"PostgreSQL Composite Types"},"content":{"rendered":"\n

Summary:<\/strong> In this tutorial, you’ll learn how to use the PostgreSQL composite types and effectively manipulate composite columns.<\/p>\n\n\n\n

Introduction to PostgreSQL composite types #<\/a><\/h2>\n\n\n\n

In PostgreSQL, a composite type represents the structure of a row or record. A composite type is a list of field names and their data types. <\/p>\n\n\n\n

PostgreSQL allows you to use composite types in the same way as simple types. <\/p>\n\n\n\n

For example, you can use composite types for table columns, function arguments, and function return types.<\/p>\n\n\n\n

Creating composite types #<\/a><\/h3>\n\n\n\n

To create a new composite type, you use the CREATE TYPE<\/code> statement as follows:<\/p>\n\n\n

CREATE<\/span> TYPE<\/span> type_name AS<\/span> (\n    field1 data_type,\n    field2 data_type,\n    ...\n);<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax:<\/p>\n\n\n\n