Am Montag, den 07.02.2005, 20:05 -0200 schrieb Clodoaldo Pinto: > On Mon, 07 Feb 2005 13:51:46 -0800, Joshua D. Drake > <jd@xxxxxxxxxxxxxxxxx> 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. Will this go into the same database? If so, you should probably use: CREATE TABLE targettable AS select data, usuario, sum(pontos) as sum_pontos, sum(wus) as sum_wus from usuarios group by data, usuario; If you are going to insert this into another database, consider doing the step above and then use pg_dump -t targettable to get a nice dump you can easily restore. You can also use copy to dump your own. HTH Tino ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
