X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6D2A1474E61 for ; Mon, 3 Mar 2003 04:20:28 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 88049-06 for ; Mon, 3 Mar 2003 04:20:26 -0500 (EST) Received: from crichton.netkonect.net (kryton.netkonect.net [194.62.44.62]) by postgresql.org (Postfix) with ESMTP id 28C1E474E42 for ; Mon, 3 Mar 2003 04:20:26 -0500 (EST) Received: from cheetah.webtribe.net (cheetah.webtribe.net [194.164.194.4]) by crichton.netkonect.net (Postfix) with ESMTP id B170F7D4EB for ; Mon, 3 Mar 2003 09:16:03 +0000 (GMT) Received: from localhost (cheetah.webtribe.net [194.164.194.4]) by cheetah.webtribe.net (Postfix) with SMTP id 475E818332 for ; Mon, 3 Mar 2003 09:16:02 +0000 (GMT) Cc: Subject: copy help Content-type: text/plain X-mailer: WebMail Date: Mon, 3 Mar 2003 09:16 +0000 Mime-version: 1.0 To: pgsql-sql@postgresql.org From: val@webtribe.net Message-Id: <20030303091602.475E818332@cheetah.webtribe.net> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/59 X-Sequence-Number: 12099 I am trying to copy out about 50G of data. When I used copy table X to '/opt/x.csv' using delimiters ','=20 with null as ''; and x.csv reached a size of 2G, I got the error message that the=20 file was too big. How can I get around this without moving things out in smaller=20 packages (more time-consuming)?