On Wed, Oct 28, 2015 at 3:35 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote: The cheat is to read the on disk file and write it into an in memory file and then use that with STDIN. Something like: sql_copy = "COPY " + self.pg_tbl_name sql_copy += " FROM STDIN WITH CSV DELIMITER '\t'" cur_copy.copy_expert(sql_copy, mem_file)And you don't actually need a "memory file", any object implementing "read" method, such as a normal fie object should just work:file=open('1.txt', 'r')cur_copy.copy_expert(sql_copy, file)--Alex
The cheat is to read the on disk file and write it into an in memory file and then use that with STDIN. Something like: sql_copy = "COPY " + self.pg_tbl_name sql_copy += " FROM STDIN WITH CSV DELIMITER '\t'" cur_copy.copy_expert(sql_copy, mem_file)
psycopg by date:
Соглашаюсь с условиями обработки персональных данных