On Friday 10 June 2005 9:33 am, Lee Wu wrote: > Even without saving to file, it is still killed: >... > My_db=# select * from a_table; > Killed >... The previous examples don't work for me. In psql try this: --First set the output to a file \o 'my_output.txt' --Now run the query select * from myfile; --Quit and check your results \q If you have a very large table you can exhaust memory on the client side unless you are writing the data directly to a file. Cheers, Steve
