1. Scott
  2. as Valentina DB Server
  3. Monday, June 28 2021, 01:09 PM
  4.  Subscribe via email
I am having a senior moment - I cannot for the life of me, remember how to pull Enum types from the DB in order to display in a GUI. For example, how to pull types and list them in Xojo or PHP listbox/dropdowns.
Comment
There are no comments made yet.
Ivan Smahin Accepted Answer

CREATE TYPE mood AS ENUM8 ('sad', 'ok', 'happy');
SELECT fld_specific_info FROM (SHOW TYPES) WHERE fld_name = 'mood';
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 1
Scott Accepted Answer
Thanks - I just knew it was something that easy. I am embarrassed now...:o
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.