On 02/16/2013 09:52 AM, Andrew Taylor wrote:
Unfortunately my starting point is data in the format of that example line. I hasn't spotted the lack of quotes on the first value. Given this format, is my best bet to write a script transforming it pre-import to postgres? I.e. are there no arguments I could pass to the import process to handle this directly? Thanks
Yes, but we need to see the actual import code i.e COPY table_name FROM file_name
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general