Re: [GENERAL] Copying entire tsv record (from file) into a single field

[Raymond O'Donnell]

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
r...@iol.ie

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general