Re: CSV import / export

From: Quan Zongliang <quanzongliang(at)gmail(dot)com>
To: "Robins Tharakan" <tharakan(at)gmail(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: CSV import / export
Date: 2008-11-27 05:24:49
Message-ID: 20081127132747.E081.4125B4E5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi, Tharakan

This item is already in my plan.
I am thinking what function should be supported and got some idea.

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.)
--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.
--and so on

wxWidgets has some class that support charset convertion.

-----------------------------------------------
Quan Zongliang
quanzongliang(at)gmail(dot)com
CIT Japan: http://www.cit.co.jp
CIT China: http://www.citbj.com.cn

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2008-11-27 08:45:05 Re: CSV import / export
Previous Message Robins Tharakan 2008-11-27 02:00:05 CSV import / export