Request a Demo
Home   >   mailing lists

Re: Good Delimiter for copy command - Mailing list pgsql-general

From Jasen Betts
Subject Re: Good Delimiter for copy command
Date
Msg-id gnjl1a$k71$7@reversiblemaps.ath.cx
Whole thread Raw
In response to Re: Good Delimiter for copy command  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
Tree view 
On 2009-02-12, SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com> wrote:
> --0-1509090113-1234471898=:21817
> Content-Type: text/plain; charset=iso-8859-1
> Content-Transfer-Encoding: quoted-printable
>
> My data fields contains commas, tabs,'|'=A0 etc. So I cant use them as del=
> imiters..so I need a unique may be non-character to use as a delimiter...

posgres will escape the delimiters (tabs come out at \t)

csv will work too (but with a different quoting convention)

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump?
Next
From: Harald Armin Massa
Date:
Subject: \l of psql 8.4 looks ... unreadable on 80char default