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