On Thu, May 1, 2014 at 1:30 AM, bricklen <bricklen@xxxxxxxxx> wrote: > > On Wed, Apr 30, 2014 at 1:07 AM, Willy-Bas Loos <willybas@xxxxxxxxx> wrote: >> >> >> Hi, >> >> I have a 56GB textfile that i want to import into postgres. >> The file is tab delimited and not quoted. > > > Would Pgloader be an option? http://tapoueh.org/pgloader/ Or pg_bulkload? Contrary to the in-core COPY, it can filter "incorrect" tuple data at the line level. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
