Skip to content

Content Tagged "psycopg"

Page 1 of 1

Content Tagged "psycopg"

Add XML to PostgreSQL from Python

July 24, 2015Category: Software
One of the projects I worked on was to import a large number of XML files in a PostgreSQL database (as XML files). I chose python to do it. Here are the steps: Database The data source is the SCOPUS database which has a silly number of entries (approx 20,000,000), most containing 2 XML files…

Load a CSV File with Header in Postgres via Psycopg

July 5, 2014Category: Software
My task is to create a script to load a bunch of files into a DB model. The files are CSV, with quoted strings and headers. Postgres has a COPY command which I find fabulous for loading data. unfortunately, the psycopg implementations copy_from() , copy_to() and copy_expert() have very few examples…

All tags