[
https://issues.apache.org/jira/browse/AIRFLOW-1726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16211541#comment-16211541
]
ASF subversion and git services commented on AIRFLOW-1726:
----------------------------------------------------------
Commit 6372770be6aab67654cede81d6b027a838077a8a in incubator-airflow's branch
refs/heads/master from [~andyxhadji]
[ https://git-wip-us.apache.org/repos/asf?p=incubator-airflow.git;h=6372770 ]
[AIRFLOW-1726] Add copy_expert psycopg2 method to PostgresHook
Executes SQL using psycopg2 copy_expert method
Necessary to execute COPY command without access to a superuser
Closes #2698 from andyxhadji/AIRFLOW-1726
> Copy Expert command for Postgres Hook
> -------------------------------------
>
> Key: AIRFLOW-1726
> URL: https://issues.apache.org/jira/browse/AIRFLOW-1726
> Project: Apache Airflow
> Issue Type: Improvement
> Reporter: Andy Hadjigeorgiou
> Assignee: Andy Hadjigeorgiou
> Priority: Minor
>
> The Copy command is useful for postgres users, and it's client-based version
> "\COPY" can be frustrating to use due to python escape character shenanigans.
> Fortunately, psycopg2 supports a copy_expert method that simplifies the
> command and it's options, so I think it would be a useful addition to the
> PostgresHook.
> I'm working on the PR now, will post here when complete.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
