airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <>
Subject [jira] [Commented] (AIRFLOW-1726) Copy Expert command for Postgres Hook
Date Thu, 19 Oct 2017 18:52:00 GMT


ASF subversion and git services commented on AIRFLOW-1726:

Commit 6372770be6aab67654cede81d6b027a838077a8a in incubator-airflow's branch refs/heads/master
from [~andyxhadji]
[;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:
>             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

View raw message