Arnaud Lesauvage <[EMAIL PROTECTED]> writes: > When trying to import a 20M rows csv file into PostgreSQL, I > get :
> ERROR: out of memory > État SQL :53200 > Détail :Failed on request of size 1073741823. > Contexte : COPY tmp, line 1 Can you put together a self-contained example? The reference to "line 1" suggests that you wouldn't need the whole 20M row file, just the first few rows ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/