Re: Copying entire tsv record (from file) into a single field - Mailing list pgsql-general

On 07/12/2010 11:07, Allan Kamau wrote:
> I would like to use copy to populate a single row in table with data
> from a tsv file for further transformations.
> I seem not find a way to stop copy from seeing that the tsv file does
> indeed contain fields.
> This my current query
>
>         COPY raw_data
>         (
>         raw_record
>         )
>         FROM
>         '/tmp/some.tsv'
>         ;

You can specify the character which COPY sees as the field delimiter to
be something other than a tab - maybe a comma, if there are no commas in
your input:

   copy raw_data(raw_record)
   from '/tmp/some.tsv'
   with delimiter ',';

Would that do the job?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie