sf_task.sql

--CREATE EXTENSION file_fdw;
--CREATE SERVER sfcsv FOREIGN DATA WRAPPER file_fdw;
CREATE FOREIGN TABLE sf_task (
Id text,
WhoId text,
WhatId text,
Subject text,
ActivityDate text,
Status text,
Priority text,
OwnerId text,
Description text,
Type text,
IsDeleted text,
AccountId text,
IsClosed text,
CreatedDate text,
CreatedById text,
LastModifiedDate text,
LastModifiedById text,
SystemModstamp text,
IsArchived text,
ActivityOriginType text,
IsVisibleInSelfService text,
CallDurationInSeconds text,
CallType text,
CallDisposition text,
CallObject text,
ReminderDateTime text,
IsReminderSet text,
RecurrenceActivityId text,
IsRecurrence text,
RecurrenceStartDateOnly text,
RecurrenceEndDateOnly text,
RecurrenceTimeZoneSidKey text,
RecurrenceType text,
RecurrenceInterval text,
RecurrenceDayOfWeekMask text,
RecurrenceDayOfMonth text,
RecurrenceInstance text,
RecurrenceMonthOfYear text,
RecurrenceRegeneratedType text,
Event_Status__c text,
Hours__c text,
Activity_Type_2__c text,
qbdialer__CallRecordingURL__c text,
qbdialer__Call_Date_Time__c text,
qbdialer__Call_Dial_Number__c text,
qbdialer__Call_Hour__c text,
qbdialer__Call_Lead_Status__c text,
qbdialer__Call_Ring_Time__c text,
qbdialer__Call_Time_Zone__c text,
qbdialer__Callback_Date_Time__c text,
qbdialer__ImpressionId__c text,
qbdialer__SMSReminder__c text) SERVER sfcsv
  OPTIONS ( filename '/home/salesforce/archive/salesforce/Task.csv', format 'csv', header 'true');
ALTER TABLE sf_task OWNER TO salesforce;