Allan Kamau wrote: > #COPY a.t(raw_data)FROM '/data/tmp/t.txt' WITH FORMAT text; > > yields "ERROR: syntax error at or near "FORMAT" You'll have to use the syntax as documented: COPY ... FROM ... WITH (FORMAT 'text'); Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general