DROP TABLE curo_sheet;
CREATE TABLE curo_sheet
("Entity Display Name" varchar,
"Entity Logical Name" varchar,
"Attribute DisplayName" varchar,
"Attribute Logical name" varchar,
"Attribute Type" varchar,
"On Form?" varchar,
"Form Section" varchar,
"Mandatory Recommended" varchar,
"Picklist option set" varchar,
"Lookup target entity" varchar,
"String max length" varchar,
"Numeric min value" varchar,
"Numeric max value" varchar,
"Numeric precision" varchar,
"DateTime just Date" varchar,
"Boolean false value" varchar,
"Boolean default value" varchar,
"Audited" varchar,
"Searchable" varchar,
"Description" varchar,
"Type" varchar
);
copy curo_sheet FROM '/Users/yuhao.huang/Documents/curo_sheet.csv' DELIMITER ',' CSV HEADER; \
psql
select "Entity Display Name", "Picklist option set" from curo_sheet where "Picklist option set" like '%Annual%';