Re: Feature idea: Add support for PostgreSQL's COPY command in contrib.postgres

2015-08-08 Thread William Chambers
+1 for this integration. This is a great feature that I've been using on projects as well. I'd love to be able to do it within django rather than hack my own sql scripts around it. The efficiency/speed up is very real. This solves the problem that when working with data where people replicate

Re: Feature idea: Add support for PostgreSQL's COPY command in contrib.postgres

2015-07-28 Thread Aaron Williams
+1 for this feature addition. I work with a lot of public data and I almost always go through the steps of loading data into PostgreSQL and building from there. COPY reduces data load time significantly so a core load command for Django is welcome. I've used LOAD DATA INFILE for MySQL on occasi

Re: Feature idea: Add support for PostgreSQL's COPY command in contrib.postgres

2015-07-27 Thread Ben Welsh
Glad you're interested! 1. Yes you can. You can use the field or model method transformations to provide any SQL you'd like. PostgreSQL has a to_timestamp

Re: Feature idea: Add support for PostgreSQL's COPY command in contrib.postgres

2015-07-23 Thread thinkwelldesigns
That looks interesting - I might be able to use your module for a project I'll be working on soon. Two questions I had about data transformation from the temp column to model column. 1. Can you create datetime stamps from the text data? 2. Can you skip rows where a column == "unwanted data"? Pa

Feature idea: Add support for PostgreSQL's COPY command in contrib.postgres

2015-07-18 Thread Ben Welsh
Hello, I am a big fan of PostgreSQL's excellent bulk loader COPY . It can rapidly load a CSV file directly into the database, an oftentimes tedious task that I have to do frequently as part of my job. I am not a big fan of having to wri