Re: COPY formatting

Karel, Andrew, Fernando:

> On Wed, Mar 17, 2004 at 11:02:38AM -0500, Tom Lane wrote:
> > Karel Zak <zakkr@zf.jcu.cz> writes:
> > >  The formatting function API can be pretty simple:
> > >  text *my_copy_format(text *attrdata, int direction,
> > >              int nattrs, int attr, oid attrtype, oid relation)

No offense, but isn't this whole thing more appropriate for a client program?
Like the pg_import and pg_export projects on GBorg?   Has anyone looked at
those projects?

I can see making a special provision for CSV in COPY, just because it's such a
universal format.   But I personally don't see that a complex, sophisticated
import/export formatter belongs on the SQL command line.   Particularly since
most users will want a GUI to handle it.

And, BTW, I deal with CSV *all the time* for my insurance clients, and I can
tell you that that format hasn't changed in 20 years.   We can hard-code it
if it's easier.

--
-Josh BerkusAglio Database SolutionsSan Francisco