Skip site navigation (1) Skip section navigation (2)

Re: proper export table to csv? multilineproblem.

From: Reid Thompson <Reid(dot)Thompson(at)ateb(dot)com>
To: peter pilsl <pilsl(at)goldfisch(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: proper export table to csv? multilineproblem.
Date: 2007-02-26 18:20:23
Message-ID: 1172514023.15824.55.camel@localhost (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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 ^

In response to


pgsql-general by date

Next:From: Reid ThompsonDate: 2007-02-26 18:21:46
Subject: Re: proper export table to csv? multilineproblem.
Previous:From: Ron JohnsonDate: 2007-02-26 18:19:10
Subject: Re: General Ledger db design

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group