out of memory error on dumping over 1,000,000 to file

From: Clayton Cottingham <drfrog(at)smartt(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: out of memory error on dumping over 1,000,000 to file
Date: 1999-08-24 10:00:08
Message-ID: 37C26D28.E0C908BF@smartt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Drinks, Ivan - ITD 1999-08-24 11:51:27 Remove
Previous Message Roberto Perez Lita 1999-08-24 09:17:08 Accessing to a granted table.