Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Use of PostgreSQL COPY statement #21

Closed
inikolaev opened this issue Aug 8, 2016 · 3 comments
Closed

Use of PostgreSQL COPY statement #21

inikolaev opened this issue Aug 8, 2016 · 3 comments
Labels
enhancement

Comments

@inikolaev
Copy link

Is it possible to load a local file into a table on remote server using COPY statement?
@elprans
Copy link
Member

elprans commented Aug 10, 2016

We'll add support for COPY protocol soon.

@pmart123
Copy link

Yes, that would be a great addition. Do you plan to create functionality similar to copy expert in psycopg2, or also a higher level function as well?

elprans added a commit that referenced this issue May 7, 2017
@elprans
Add support for COPY OUT
d81681c 
This commit adds two new Connection methods: copy_from_table() and
copy_from_query() that allow copying the contents of a table or
the results of a query using PostgreSQL COPY protocol.

Issue #21.
@elprans elprans mentioned this issue May 7, 2017
Merged
elprans added a commit that referenced this issue May 7, 2017
@elprans
Add support for COPY OUT
196937c 
This commit adds two new Connection methods: copy_from_table() and
copy_from_query() that allow copying the contents of a table or
the results of a query using PostgreSQL COPY protocol.

Issue #21.
elprans added a commit that referenced this issue May 7, 2017
@elprans
Add support for COPY OUT
67ed413 
This commit adds two new Connection methods: copy_from_table() and
copy_from_query() that allow copying the contents of a table or
the results of a query using PostgreSQL COPY protocol.

Issue #21.
elprans added a commit that referenced this issue May 8, 2017
@elprans
Add support for COPY OUT
7ccd796 
This commit adds two new Connection methods: copy_from_table() and
copy_from_query() that allow copying the contents of a table or
the results of a query using PostgreSQL COPY protocol.

Issue #21.
elprans added a commit that referenced this issue May 8, 2017
@elprans
Add support for COPY OUT
bd3eb7e 
This commit adds two new Connection methods: copy_from_table() and
copy_from_query() that allow copying the contents of a table or
the results of a query using PostgreSQL COPY protocol.

Issue #21.
elprans added a commit that referenced this issue May 8, 2017
@elprans
Add support for COPY OUT
823a333 
This commit adds two new Connection methods: copy_from_table() and
copy_from_query() that allow copying the contents of a table or
the results of a query using PostgreSQL COPY protocol.

Issue #21.
elprans added a commit that referenced this issue May 9, 2017
@elprans
Add support for COPY OUT
48d69f5 
This commit adds two new Connection methods: copy_from_table() and
copy_from_query() that allow copying the contents of a table or
the results of a query using PostgreSQL COPY protocol.

With help from @1st1.

Issue #21.
1st1 pushed a commit that referenced this issue May 10, 2017
@elprans @1st1
Add support for COPY OUT
c09c697 
This commit adds two new Connection methods: copy_from_table() and
copy_from_query() that allow copying the contents of a table or
the results of a query using PostgreSQL COPY protocol.

With help from @1st1.

Issue #21.
1st1 pushed a commit that referenced this issue May 10, 2017
@elprans @1st1
Add support for COPY OUT
5662d9f 
This commit adds two new Connection methods: copy_from_table() and
copy_from_query() that allow copying the contents of a table or
the results of a query using PostgreSQL COPY protocol.

With help from @1st1.

Issue #21.
elprans added a commit that referenced this issue May 10, 2017
@elprans
Add support for COPY IN
f19a893 
This commit adds two new Connection methods: copy_to_table() and
copy_records_to_table() that allow copying data to the specified
table either in text or, in the latter case, record form.

Related-To #123.
Closes #21.
@elprans elprans mentioned this issue May 10, 2017
Merged
elprans added a commit that referenced this issue May 11, 2017
@elprans
Add support for COPY IN
a50fa47 
This commit adds two new Connection methods: copy_to_table() and
copy_records_to_table() that allow copying data to the specified
table either in text or, in the latter case, record form.

Closes #123.
Closes #21.
elprans added a commit that referenced this issue May 11, 2017
@elprans
Add support for COPY IN
b310291 
This commit adds two new Connection methods: copy_to_table() and
copy_records_to_table() that allow copying data to the specified
table either in text or, in the latter case, record form.

Closes #123.
Closes #21.
elprans added a commit that referenced this issue May 11, 2017
@elprans
Add support for COPY IN
445775c 
This commit adds two new Connection methods: copy_to_table() and
copy_records_to_table() that allow copying data to the specified
table either in text or, in the latter case, record form.

Closes #123.
Closes #21.
elprans added a commit that referenced this issue May 11, 2017
@elprans
Add support for COPY IN
01830c3 
This commit adds two new Connection methods: copy_to_table() and
copy_records_to_table() that allow copying data to the specified
table either in text or, in the latter case, record form.

Closes #123.
Closes #21.
elprans added a commit that referenced this issue May 11, 2017
@elprans
Add support for COPY IN
10d95d4 
This commit adds two new Connection methods: copy_to_table() and
copy_records_to_table() that allow copying data to the specified
table either in text or, in the latter case, record form.

Closes #123.
Closes #21.
@1st1
Copy link
Member

1st1 commented May 12, 2017

Please try asyncpg 0.11 with COPY IN/OUT support!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@1st1 @elprans @inikolaev @pmart123