Re: Import from CSV - Questions

________________________________

From: pgadmin-hackers-owner(at)postgresql(dot)org
[mailto:pgadmin-hackers-owner(at)postgresql(dot)org] On Behalf Of Joel Hainley
Sent: 09 March 2006 21:43
To: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgadmin-hackers] Import from CSV - Questions


Hello all,

I was looking over the todo list and noticed an item "import
from CSV".

I was wondering if there was more information about what the
thoughts were behind this item?

- Are you looking to be able to import a csv file into a single
table?
- Multiple tables?
- Any examples exist out there for other dbms tools that this
idea was inspired by?

To be honest I didn't realise it was there. The tool I have in mind for
more general data movement is a simplified version of something like
Microsoft's DTS, essentially with input, transform and output modules.
The input modules might get data from ODBC or a CSV file for example,
the transform module would allow either straight mapping of source to
target columns, and (probably) python based transformation for more
complex stuff, and the output module would insert the data into
PostgreSQL, a CSV file or and ODBC data source etc.

That is clearly a complex project though... An alternative might be a
simple wizard, activated by a 'load data' option on the table context
menu

Magnus was also talkng about XML export (and import?) so perhaps he has
some ideas.

Obviously i'm new to the project but i'd like to try to dig in
and give a hand, and thought this might be something I could lend a hand
with.

Great - we're happy to work with new developers whenever we can.

Regards, Dave