Sample Header Ad - 728x90

Convert PostgreSQL array type

0 votes
1 answer
670 views
Given an enum type (e.g. letter). What is the syntax to convert an existing array to the enum type? The existing values are valid for the enum. For example, how would I convert letter_data in: create table sample ( letter_data text[]; ); To the letter enum?
Asked by gerardw (115 rep)
Aug 29, 2023, 06:16 PM
Last activity: Aug 30, 2023, 12:06 AM