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@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
