Back to Browse

How to use ENUM data type in PostgreSQL table.

10.7K views
Nov 27, 2021
6:39

How to add ENUM data type to your table design in PostgreSQL. enum datatype postgre How to use pg_type to located data type how to use pg_enum to locate enum elements or members enumerated type. Enumerated types, on the other hand, make the code more self-documenting. enumerations assign related names to a set of integer values. PostgreSQL provides an enumerated type ENUM with allowable values specified as strings when a table is created. An ENUM type is a special data type that enables for a variable to be a set of predefined constants ------------------------------------------------------*****---------------------------------------------------------------------- If you've found this videos useful and wish to show your support with a small XLM donation, feel free to use the following values: XLM address GC23BCI644P66PPNRGRMKFFVQZZXE3CSCGMFIYFV5OW4WCPM2XICKWQZ XLM Memo 502087138 ------------------------------------------------------*****-------------------------------------------------------------------- #softwarenuggets , #postgresql ,#postgres , #postgresEnum

Download

1 formats

Video Formats

360pmp49.6 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.