Re: select * and save into a text file failed

"Lee Wu" <Lwu@mxlogic.com> writes:
> My_db=3D# select * from a_table;
> Killed

Apparently the table is bigger than psql can hold in memory?

The simplest way to do this is certainly to use pg_dump in one-table
mode.  If you're intent on using psql, you could use a cursor or
OFFSET/LIMIT to fetch part of the table at a time.

            regards, tom lane