| From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Good Delimiter for copy command |
| Date: | 2009-02-19 12:58:18 |
| Message-ID: | gnjl1a$k71$7@reversiblemaps.ath.cx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On 2009-02-12, SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harald Armin Massa | 2009-02-19 13:03:28 | \l of psql 8.4 looks ... unreadable on 80char default |
| Previous Message | Jasen Betts | 2009-02-19 12:42:36 | Re: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zdenek Kotala | 2009-02-19 12:58:51 | Re: vacuumdb --freeze |
| Previous Message | Heikki Linnakangas | 2009-02-19 12:01:24 | Re: Doubts about EvalPlanQual |