COPY formatting - Mailing list pgsql-hackers

From Karel Zak
Subject COPY formatting
Date
Msg-id 20040317143813.GB17580@zf.jcu.cz
Whole thread Raw
Responses Re: COPY formatting
Re: COPY formatting
Re: COPY formatting
COPY formatting
List pgsql-hackers
Hi,
in TODO is item: "* Allow dump/load of CSV format". I don't thinkit's clean idea. Why CSV and why not something other?
:-)
 
A why not allow to users full control of the format by they ownfunction. It means something like:COPY tablename [ (
column[, ...] ) ]    TO { 'filename' | STDOUT }    [ [ WITH ]          [ BINARY ]         [ OIDS ]         [ DELIMITER
[AS ] 'delimiter' ]         [ NULL [ AS ] 'null string' ]         [ FORMAT funcname ] ]          ^^^^^^^^^^^^^^^^
                                        The formatting function API can be pretty simple:
 
text *my_copy_format(text *attrdata, int direction,             int nattrs, int attr, oid attrtype, oid relation)
-- it's pseudocode of course, it should be use standard fmgrinterface.It's probably interesting for non-binary COPY
version.Comments?
   Karel

-- Karel Zak  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/


pgsql-hackers by date:

Previous
From: "BARTKO, Zoltan"
Date:
Subject: Re: Doxygen?
Next
From: Hans-Jürgen Schönig
Date:
Subject: Re: COPY formatting