Received: from dfw-ix8.ix.netcom.com (dfw-ix8.ix.netcom.com [206.214.98.8]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA32917 for ; Tue, 24 Aug 1999 06:22:02 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: (from smap@localhost) by dfw-ix8.ix.netcom.com (8.8.4/8.8.4) id EAA19524 for ; Tue, 24 Aug 1999 04:51:27 -0500 (CDT) Received: from 00-10-4b-66-ed-f1.bconnected.net(209.53.22.117) by dfw-ix8.ix.netcom.com via smap (V1.3) id rma019517; Tue Aug 24 04:51:03 1999 Sender: DrFrog@ix.netcom.com Message-ID: <37C26D28.E0C908BF@smartt.com> Date: Tue, 24 Aug 1999 10:00:08 +0000 From: Clayton Cottingham X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.3.2 i586) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: out of memory error on dumping over 1,000,000 to file Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit i keep gettin' out of memory errors when running this type of command on my tables psql database -c "select column1,column2 from table;" > 2columnsout the reason im doing it this way is to just retrieve two columns, is there as another way to do this ? i looked at the -o filename option,it still produced the same error!? possible something to add to pg_dump? the ability to dump certain columns?