zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

4 results for: in tag: python

postgresql+python: how to adapt for copy_from?

What function can I use to adapt values for suitable use in a ...COPY FROM... statement? I tried this ...adapt... function:...from psycopg2.extensions import adapt ...However, it gives the wrong thing for datetimes (appends ...::timestsamp... to the strin...
database postgresql python sql sqlbulkcopy
asked by Claudiu

cursor.copy_from failed in postgres

I am facing problems in coping data from one db to another db here is python code....import psycopg2 db = psycopg2.connect("dbname='db' user='xx' password='xx' host='127.0.0.2'") st = db.cursor(); db_l = psycopg2.connect("dbname='xx' user='xx' password=...
cursor postgresql psycopg2 python sqlbulkcopy
asked by sharafjaffri

Python and SQL Bulk Insert

I am using IronPython to create a data array and I need to insert this array to MS SQL Server. The .Net class I'm using is SqlBulkCopy (part of System.Data.SqlClient)....I have found this StackOverflow article quite useful ...SqlBulkCopy from a list...How...
.net ironpython python sqlbulkcopy sql-server
asked by Casual Pundit

psycopg2 copy_from raises asynchronous ProgrammingError with sync connection in celery task

My problem is I am facing...ProgrammingError: copy_from cannot be used with an asynchronous callback....while trying to ...copy_from... without async connection. This must be stated, I am creating connection from a celery task. Can someone give me a clu...
asynchronous celery psycopg2 python sqlbulkcopy
asked by Phil Matiash

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...