psycopg2.ProgrammingError: syntax error at or near "stdin" error when trying to copy_from redshift

Question

I am having this problem when I am trying to copy to AWS redshift. This is the code I am trying to run:

with open('path/to/files, 'rb') as fo:
    cursor.copy_from(fo, 'schema.table', sep=',')
    cursor.commit()

And I encountered the error:

psycopg2.ProgrammingError: syntax error at or near "stdin" 
LINE 1: ...Y schema.table FROM stdin WITH...

I am running python 3.5 with psycopg2. Hope that you guys can help! Thx in advance!

Craig Ringer · Accepted Answer · 2016-12-01 07:09:50Z

8

AWS Redshift is not PostgreSQL, though it supports a subset of PostgreSQL syntax and functionality.

It does not have COPY ... FROM STDIN.

See the manual for how to use COPY on Redshift.

answered Dec 1, 2016 at 7:09

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Larry Over a year ago

Thank you for your help!

Thom Rogers Over a year ago

@CraigRinger I understand your point and see how COPY is usedfrom a command line or a DB tool (DBeaver, etc), but how do you do a copy to a table from within a python script. What module and syntax would you suggest?

Craig Ringer Over a year ago

You probably have to use multi-inserts instead, or generate data to upload to s3 and COPY from there. shrug. I don't use Redshift. Maybe you should post a new question and link back to this one?

PyBoss · Accepted Answer · 2019-02-01 23:52:33Z

0

check this solution Python psycopg2 insert NULL in some rows in postgresql table

for insert multiple rows or python dataframe in Redshift

answered Feb 1, 2019 at 23:52

PyBoss

6312 gold badges8 silver badges25 bronze badges

Collectives™ on Stack Overflow

psycopg2.ProgrammingError: syntax error at or near "stdin" error when trying to copy_from redshift

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related