On 10/15/2013 02:47 PM, Andres Freund wrote: > On 2013-10-15 15:17:58 +0200, Andres Freund wrote: >> If we go for CSV I think we should put the entire primary key as one >> column (containing all the columns) and the entire row another. just use JSON :) >> What about columns like: >> * action B|I|U|D|C >> >> * xid >> * timestamp >> >> * tablename >> >> * key name >> * key column names >> * key column types >> >> * new key column values >> >> * column names >> * column types >> * column values >> >> * candidate_key_changed? >> * old key column values >> >> And have output plugin options >> * include-column-types >> * include-column-names >> * include-primary-key >> >> If something isn't included it's simply left out. >> >> What still need to be determined is: >> * how do we separate and escape multiple values in one CSV column >> * how do we represent NULLs
or borrow whatever possible from pg_dump as they have needed to solve most of the same problems already and consistency is good in general > > Greetings, > > Andres Freund > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers