| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | sharmi_jo(at)yahoo(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org, Sam Mason <sam(at)samason(dot)me(dot)uk> |
| Subject: | Re: Good Delimiter for copy command |
| Date: | 2009-02-12 21:11:44 |
| Message-ID: | 49949090.80203@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On 12/02/2009 20:51, SHARMILA JOTHIRAJAH wrote:
> My data fields contains commas, tabs,'|' etc. So I cant use t hem as
> delimiters..so I need a unique may be non-character to use as a
> delimiter...
Indeed you do... and a quick RTFM reveals that you can set a character
of your choice:
http://www.postgresql.org/docs/8.3/interactive/sql-copy.html
...look for the "delimiter" parameter.
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gould | 2009-02-12 21:15:06 | Re: Good Delimiter for copy command |
| Previous Message | SHARMILA JOTHIRAJAH | 2009-02-12 20:51:38 | Re: Good Delimiter for copy command |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gould | 2009-02-12 21:15:06 | Re: Good Delimiter for copy command |
| Previous Message | John Lister | 2009-02-12 21:11:07 | Re: database corruption help |