I'm looking at a code base that I have inherited. I'm new to Postgres (but have an Oracle background), and I think this in one of the queries is an example of an enum. Can someone confirm if I'm correct in this thinking, and if not then what this is, and how I find out more about it.
SELECT fp.id AS fund_part_id, fp.fund_id, fp.principle_amount, fp.detail FROM finance.fund_part fp WHERE fp.status = 'live'::finance.fund_part_status;
I can see if the pg_enum catalog (table) that there are a series of records that belong to one
enumtypid oid. Some of the entries in the
enumlabel name column are
['live', 'for sale', 'pre-agrement']