|
Postgresql 9.3 I am downloading data that I want to import into a table. The data comes in tab delimited, CRLF format. I am using plpython to get the data and I wanted to use copy with stdin to import it without having to save it to a file. To do this, I am setting sys.stdin to a StringIO object with my data inside. However, when I call copy I am getting SPI_ERROR_COPY, which the docs define as "if COPY TO stdout or COPY FROM stdin was attempted" which is exactly what I am trying to do (so the error is logical). Is there another method of loading delimited data in bulk without saving it as a file? Thanks Sim |
