When I ran that command (select * from pg_stat_activity"), it returned the first six lines of the scripts. I'm fairly sure it has gotten a bit beyond that (been running over 24 hours now, and the size has increased about 300 GB). Am I missing something for it to tell me what the last line processed was?
that means your GUI lobbed the entire file at postgres in a single PQexec call, so its all being executed as a single statement.
psql -f "filename.sql" dbname would have processed the queries one at a time.
-- john r pierce 37N 122W somewhere on the middle of the left coast