Re: CSV import / export

From: "Robins Tharakan" <tharakan(at)gmail(dot)com>
To: "Guillaume Lelarge" <guillaume(at)lelarge(dot)info>, "Quan Zongliang" <quanzongliang(at)gmail(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: CSV import / export
Date: 2008-11-27 09:03:36
Message-ID: 36af4bed0811270103s45c205bajf817530b264edee7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Oops. My bad. I should have checked the mailing list, before posting that
one then :)
Frankly, I think unless a job is high priority, its better if one person
works on this dedicatedly. Sometimes coordination/syncing takes more
resources than development. Especially when both are working 'in their spare
time'.

Not an issue at all. I just thought that I may have some spare time and
thought of this as something to work upon.

Guess I'll go back to the ToDo and pick something else to work on.
If I can do it, that is.

Regards,
Robins Tharakan

---------- Forwarded message ----------
From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Date: 2008/11/27
Subject: Re: [pgadmin-hackers] CSV import / export
To: Quan Zongliang <quanzongliang(at)gmail(dot)com>
Cc: Robins Tharakan <tharakan(at)gmail(dot)com>, pgadmin-hackers(at)postgresql(dot)org

Quan Zongliang a écrit :
> [...]
> This item is already in my plan.
> I am thinking what function should be supported and got some idea.
>

You should work together.

> There are some commercial pruduct that coded in Java.
> Through the JDBC technology, they can support almost all database.
> We can reference their function to design our component.
>
> Import/Export should has themselves dialog. In future, they can be
> grouped into a sub-menu with Backup/Restore.
>
> The CSV(Comma-Separated Values) has itself standard "RFC 4180".
> Website: http://www.ietf.org/rfc/rfc4180.txt
>
> I plan to support it and some expansion.
> --column delimiter can be comma(std), colon, semicolon or TAB;
> (Text parser should accept any char or string to be delimiter,
ideally.
> However, this will make the function too complicated. Juest be an idea
> now.)

length delimiter is also an option.

> --text can be quoted in single or double(std) quotation;
> --multi-format date, time, numberic
> --user can adjust column order to correspond with CSV item.

This would be great.

> --and so on
>
> wxWidgets has some class that support charset convertion.
>

Take a look at the pgloader tool in pgfoundry. It also deals with this
kind of problems. You should be able to get a complete list of issues
and ways to get over them.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2008-11-27 09:19:49 Re: Are there plans to display memory usage: pg_buffercache
Previous Message Guillaume Lelarge 2008-11-27 08:52:16 Re: CSV import / export