loading curo_sheet in psql

load curo_sheet into postgres

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; 

Usage

psql

select "Entity Display Name", "Picklist option set" from curo_sheet where "Picklist option set" like '%Annual%';