On Mon, 2007-02-26 at 14:54 +0100, peter pilsl wrote:
> I need to export several tables as csv. I use the \f-command to set the
> seperator and pipe the output of my select directly to a file.
>
> Unfortunately thats all the control I have over the created csv-file. I
> cannot
> set the field-delimiter and - which is critical to me - I cannot set an
> alternate record-seperator (newline at the moment). The latter is important
> to
> me cause many of my fields-values have \n or \r in it, so the
> csv-import-filter
> has a hard time to distinguish the record-seperator from a newline inside the
> data.
>
> On the server I've postgres7.2, so the COPY-command does not know about the
> CSV-option yet (not does the postgres 8).
>
> Is there any ready tool to create flexible csv-files or any trick I did not
> find
> out yet?
>
> thnx,
> peter
>
tablename=>\pset fieldsep ,
tablename=>\pset recordsep ^
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
