"Lee Wu" <Lwu@xxxxxxxxxxx> 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
