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