out of memory errors

i try to dump records out , just two colums using

psql emq_frontend -c "select 1column,2column from table;">twocolumnsout

from a 1.2 mill db

and it gives me either out of memory
or backend close or
sent d b4 t errors
also a setallocmem()
sorry for psuedo quoting

has anyone ever seen this