out of memory error on dumping over 1,000,000 to file - Mailing list pgsql-sql

From Clayton Cottingham
Subject out of memory error on dumping over 1,000,000 to file
Date
Msg-id 37C26D28.E0C908BF@smartt.com
Whole thread Raw
List 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?






pgsql-sql by date:

Previous
From: "Roberto Perez Lita"
Date:
Subject: Accessing to a granted table.
Next
From: "Drinks, Ivan - ITD"
Date:
Subject: Remove