Clayton Cottingham wrote:
> 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?
>
> ************
it seems the dump stops at approx the half way point
this happens even on a limited selectect
as
if table has 1 mill rows
select * from table limit 500000,75000;
it would produce an out of memory
has anyone else experienced this?
my hardware/os is k166 w 64mb ram
running on linux kernel 2.3.2 and glibc2.1