Skip site navigation (1) Skip section navigation (2)

Re: Import from CSV - Questions

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Joel Hainley" <joelh(dot)pg(at)gmail(dot)com>
Cc: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>,<pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Import from CSV - Questions
Date: 2006-03-14 20:44:41
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCEA0F86B@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgadmin-hackers
> 
> Magnus, any chance of getting a look at what you currently 
> have to help guide me in the appropriate direction?

Umm. That would kind of assume it's written down in a comprehensible
way. Which it isn't, of course :-) 

The general ideas so far have been, off the top of my head:

* Pluginnable set of "readers" and "writers". Originally I'd see
postgresql, odbc, xml and possibly csv. Pg driver would be optimised to
use COPY when available.

* Pluginnable set of "transforms" that would operate on the rows. By
default things like copy and concatenate and maybe regexp. Future
enhancement would be a python extension, as Dave mentioned. (Or really,
anything else)

* I was envisioning a split of say "package", "job", "step" (terms of
course subject to discussion). package basically a set of job, job a set
of steps. Things like connections would be defined at the "job" level,
along wiht parmaeters for transaction control etc. (So you can use it to
transfer 10 different tables within a single transaction, something I
need all the time).

* I'd like to see the job format stored as XML with a well defined
schema, so different appliations can generate it - both manually
(GUI-wise from pgadmin and phppgadmin etc) and automatically.

* The "engine" should be available both as a commandline tool (which
must not require X libraries etc, because it should be deployable
"everywhere") and as  acommand inside pgadmin (like MS DTS)


Um. I think that's about it. I had some sketches of classes and
interfaces around (not complete, but an idea), but I can't find them :(

//Magnus

Responses

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2006-03-14 20:54:51
Subject: Re: Import from CSV - Questions
Previous:From: Joel HainleyDate: 2006-03-14 20:28:06
Subject: Re: Import from CSV - Questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group