Re: CSV import / export - Mailing list pgadmin-hackers

From Quan Zongliang
Subject Re: CSV import / export
Date
Msg-id 20081127132747.E081.4125B4E5@gmail.com
Whole thread Raw
In response to CSV import / export  ("Robins Tharakan" <tharakan@gmail.com>)
Responses Re: CSV import / export  (Guillaume Lelarge <guillaume@lelarge.info>)
List 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@gmail.com
CIT Japan:  http://www.cit.co.jp
CIT China:  http://www.citbj.com.cn


pgadmin-hackers by date:

Previous
From: "Robins Tharakan"
Date:
Subject: CSV import / export
Next
From: Guillaume Lelarge
Date:
Subject: Re: CSV import / export