Re: Out of memory error

On Mon, 07 Feb 2005 13:51:46 -0800, Joshua D. Drake
<jd(at)commandprompt(dot)com> wrote:

> Well your first email didn't explain that you were doing the below :)

In the first email I was not doing the insert. I was executing a psql script:

$ psql -e -f groupdup.psql ks2

This was the groupdup.psql script:

\pset format unaligned
\pset fieldsep '\t'
\pset tuples_only
\o '/KakaoStats/bak/groupdup.txt'
select
data,
usuario,
sum(pontos),
sum(wus)
from usuarios
group by data, usuario
;
\o
\pset tuples_only
\pset format aligned

I was planning to insert the file with copy from.

> Is this the entire function?

Yes, it is the entire function.