From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Quan Zongliang <quanzongliang(at)gmail(dot)com> |
Cc: | Robins Tharakan <tharakan(at)gmail(dot)com>, pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: CSV import / export |
Date: | 2008-11-27 08:52:16 |
Message-ID: | 492E5FC0.5050404@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robins Tharakan | 2008-11-27 09:03:36 | Re: CSV import / export |
Previous Message | Guillaume Lelarge | 2008-11-27 08:45:05 | Re: CSV import / export |