Skip to content

typed-table (GN034)#

Automatic fix is not available.

What it does#

Checks for typed table.

Why not?#

A typed table takes its structure from a composite type.

A typed table is tied to its type; for example the table will be dropped if the type is dropped (with DROP TYPE ... CASCADE).

This creates a tight coupling between the table and its type. Any operations to be done to the columns of the typed table would have to be done through the type.

When should you?#

Almost Never.

Use instead:#

A template table, copying the structure with LIKE.