PostgreSQL

[Eston_Sello]

Good day,

Please assist, I am connected to the DB via postgreSQL and trying to use where clause but it is not working  the script execute successful but it does not return anything, I'm not sure if I'm going the correct thing.

below is the script I'm using

LIB CONNECT TO '';

LOAD id,
date_closed,
create_date,
probability,
color,
country_id,
date_last_stage_update,
date_action_last,
campaign_id,
day_close,
write_uid,
team_id,
day_open,
contact_name,
partner_id,
date_action_next,
city,
date_conversion,
opt_out,
date_open,
title,
partner_name,
planned_revenue,
message_last_post,
company_id,
priority,
next_activity_id,
email_cc,
type,
function,
fax,
description,
create_uid,
street2,
date_deadline,
title_action,
phone,
lost_reason,
write_date,
active,
user_id,
date_action,
name,
stage_id,
zip,
medium_id,
mobile,
last_activity_id,
street,
message_bounce,
source_id,
state_id,
email_from,
referred,
call_count,
city_id,
id_number,
contact_surname,
street3,
weighted_revenue,
passport_number,
gender,
marital_status,
dob,
x_script,
x_unique_key,
x_handset_brand,
x_preferred_communication_method,
x_still_looking_for_place_to_study,
x_terms_and_conditions,
x_middle_name,
x_id_type,
x_fields_of_study_1,
x_accommodation_gauteng,
x_accommodation_western_cape,
x_accommodation_free_state,
x_accommodation_kzn,
x_accommodation_mpumalanga,
x_accommodation_north_west,
x_accommodation_eastern_cape,
x_accommodation_northern_cape,
x_accommodation_limpopo,
x_consider_leanership,
x_applicant_regretted,
x_response_due_date,
x_program,
x_grade_12_exam_number,
x_ready_institute,
x_first_contact_date,
x_inside_sla,
x_sla_status,
x_sla_status_reason
where write_date = '2020-02-17';

[crm_lead]:
SELECT "id",
"date_closed",
"create_date",
"probability",
"color",
"country_id",
"date_last_stage_update",
"date_action_last",
"campaign_id",
"day_close",
"write_uid",
"team_id",
"day_open",
"contact_name",
"partner_id",
"date_action_next",
"city",
"date_conversion",
"opt_out",
"date_open",
"title",
"partner_name",
"planned_revenue",
"message_last_post",
"company_id",
"priority",
"next_activity_id",
"email_cc",
"type",
"function",
"fax",
"description",
"create_uid",
"street2",
"date_deadline",
"title_action",
"phone",
"lost_reason",
"write_date",
"active",
"user_id",
"date_action",
"name",
"stage_id",
"zip",
"medium_id",
"mobile",
"last_activity_id",
"street",
"message_bounce",
"source_id",
"state_id",
"email_from",
"referred",
"call_count",
"city_id",
"id_number",
"contact_surname",
"street3",
"weighted_revenue",
"passport_number",
"gender",
"marital_status",
"dob",
"x_script",
"x_unique_key",
"x_handset_brand",
"x_preferred_communication_method",
"x_still_looking_for_place_to_study",
"x_terms_and_conditions",
"x_middle_name",
"x_id_type",
"x_fields_of_study_1",
"x_accommodation_gauteng",
"x_accommodation_western_cape",
"x_accommodation_free_state",
"x_accommodation_kzn",
"x_accommodation_mpumalanga",
"x_accommodation_north_west",
"x_accommodation_eastern_cape",
"x_accommodation_northern_cape",
"x_accommodation_limpopo",
"x_consider_leanership",
"x_applicant_regretted",
"x_response_due_date",
"x_program",
"x_grade_12_exam_number",
"x_ready_institute",
"x_first_contact_date",
"x_inside_sla",
"x_sla_status",
"x_sla_status_reason"
FROM "public"."crm_lead";
//where "write_date" = '2020-02-17';

[lorenzoconforti · Accepted solution]

try without the double quotes

where write_date = '2020-02-17';