"Lee Wu" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
